• How indexes work
• How to create an index
• The different types of indexes
• When to use indexes
• When not to use indexes
In this hour, you learn how to improve SQL statement performance by creating and using indexes. You begin with the
CREATE INDEX command and learn how to use indexes that have been created on tables.
Simply put, an index is a pointer to data in a table. An index in a database is similar to an index in the back of a book. For example, if you want to reference all pages in a book that discuss a certain topic, you first refer to the index, which lists all topics alphabetically, and it refers you to one or more specific page numbers. ...