Index Manipulation

Create a simple index:

CREATE INDEX index_name
ON table_name (column_name_1, column_name_2, ...)

example:

CREATE INDEX PersonIndex
ON Person (LastName, FirstName)

Create a unique index:

CREATE UNIQUE INDEX index_name
ON table_name (column_name_1, column_name_2, ...)

example:

CREATE UNIQUE INDEX PersonIndex
ON Person (LastName DESC)

 Delete a index :

DROP INDEX table_name.index_name

example:

DROP INDEX Person.PersonIndex