An indexes are schema objects that contains an entry for each value that appears in the indexed columns of the table and provides fast access to rows.Index is a database object that makes data retrieval faster.
We can say Indexes are the easiest way to improve the performance of long running queries with full tables scan. By properly indexing large tables query completion time can go from hours to minutes.
Indexes created on column and that column is called index key.
Indexes not only improve Select queries but also it improves Update & Delete.
We can say Indexes are the easiest way to improve the performance of long running queries with full tables scan. By properly indexing large tables query completion time can go from hours to minutes.
Indexes created on column and that column is called index key.
Indexes not only improve Select queries but also it improves Update & Delete.
0 comments:
Post a Comment