RSS‎ > ‎

SQL :: What is Index?

posted Aug 8, 2012, 3:36 AM by Ashish Jain
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. There are two types on indexes: Clustered indexes and Non-clustered indexes