© Jason Strate 2019
J. StrateExpert Performance Indexing in SQL Server 2019https://doi.org/10.1007/978-1-4842-5464-6_11

11. Indexing Strategies

Jason Strate1 
(1)
Hugo, MN, USA
 

Indexing databases is often thought of as an art where the database is the canvas and the indexes are the paints that come together to form a beautiful tapestry of storage and performance. A little color here, a little color there, and paintings will take shape. In much the same way, a clustered index on a table and then a few nonclustered indexes can result in screaming performance as beautiful as any masterpiece. Going a little too abstract or minimalist with your indexing might make you feel good, but the performance will let you know it isn’t too useful.

As colorful as this ...

Get Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance 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.