Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

What is Index?

Ads

 
 

Share on Google+Share on Google+

hemant kumar
What is Index?
1 Answer(s)      6 years and 8 months ago
Posted in : SQL

What is Index?

Ads
View Answers

November 15, 2010 at 1:15 PM


Hi,

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application.

An Index can be created on a single column or a combination of columns in a database table. A table index is a database structure that arranges the values of one or more columns in a database table in specific order. The table index has pointers to the values stored in specified column or combination of columns of the table. These pointers are ordered depending on the sort order specified in the index.

Thanks.


Ads