INDEX CREATION

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.

SYNTAX

Where:

  • 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

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin