INDEX Using SQL SERVER

INDEX:The CREATE INDEX statement is used to create indexes in tables.

Indexes allow the database application to find data fast; without reading the whole table.

1.CREATE INDEX:

SYNTAX:CREATE INDEX index_name

ON Table_name(column_name)

Statement:CREATE INDEX MY ON Salary (id)

                select * from salary where id=3

2.DROP INDEX:

SYNTAX:DROP INDEX Index_name on Table_name

   Statement: Drop Index My on Salary