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
|
My Blog Title
|