The SQL INDEX helps increasing the performance of a table, by retrieving the information very quickly.

The INDEX table consists of only two columns:

  • Rowid

  • Indexed column (ordered).

When data is retrieved from a database table based on the indexed column, the index pointer looks for the Rowid and quickly locates that position. in the actual table and display, the rows sought for.




  • CREATE INDEX                               : keyword used to create an Index.

  • Index_name                                   : The name of the index which you are going to create.

  • Table_name                                   : The name of the table on which you are going to create the index.

  • Column1Name, Column2Name      : The name of the columns you want to specify index on.

Want More SQL Deep Dives