In This Chapter

•   Introduction to Indices

•   Transact-SQL and Indices

•   Guidelines for Creating and Using Indices

•   Special Types of Indices

This chapter describes indices and their role in optimizing the response time of queries. The first part of the chapter discusses how indices are stored and describes the existing forms of them. The main part of the chapter explains three Transact-SQL statements pertaining to indices: CREATE INDEX, ALTER INDEX, and DROP INDEX. After that, index fragmentation and its impact on the performance of the system will be explained. The next part of the chapter gives you several general recommendations for how and when indices should be created. The final part of the chapter describes ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th 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.