Chapter 16. Using Indexes to Improve Performance
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
What Is an Index?
Simply put, an index is a pointer to data in a table. An index in a database is very 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 ...
Get Sams Teach Yourself SQL in 24 Hours, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
