Chapter 12. Planning and Creating Indexes

IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:

  • UNDERSTAND INDEX ARCHITECTURE (Pages 408 – 419)

    • Understand Index Storage (Page 408)

    • Get Index Information (Page 411)

    • Plan Indexes (Page 416)

  • CREATE AND MANAGE INDEXES (Pages 419 – 431)

    • Create and Manage Clustered Indexes (Page 419)

    • Create and Manage Nonclustered Indexes (Page 426)

    • Use the Database Engine Tuning Advisor (Page 428)

  • MANAGE SPECIAL INDEX OPERATIONS (Pages 431 – 436)

    • Cover a Query (Page 432)

    • Optimize Logical Operations (Page 433)

    • Optimize Join Operations (Page 435)

The larger a database gets, the more difficult it is to efficiently extract information from the data store. Wading through every single data page in a data table requires extensive IO, ...

Get SQL Server® 2008 Administration: Instant Reference 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.

Start your free trial