Make an Index

Quick Notes

• Indexes may use more than one column

• You can create different indexes or different combinations of colours

• You can create different indexes with the same columns but in a different order

• If the comparison is >, ≥, <, ≤, On a key field with an index e.g. student.ID < 150 indexes that satisfy the condition will be retrieved

• Student.ID < 150 and Student.ColName > 25 This is two steps

Make an Index

// basic create index
CREATE INDEX indexName
ON tableName (colName)

// create index
CREATE INDEX indexName
ON tableName (colName[ASC/DESC])

// with unique values
CREATE UNIQUE INDEX indexName
ON tableName (colName[ASC/DESC])

// With ascending values
CREATE INDEX indexName
ON tableName (colName ASC)

// With descending values
CREATE INDEX indexName
ON tableName (colName DESC)

Drop Index

DROP INDEX indexName;