During 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.
The highlights of this hour include
How to create an index
How indexes work
The different types of indexes
When to use indexes
When not to use indexes