Zen and the Art of Indexing
Indexing and performance tuning are a mixture of art and science. The science portion includes knowing the details of how indexing works under the covers and when it makes sense to define indexes on the appropriate columns on a table. The art portion includes knowing when to stray away from what conventional wisdom tells you to do and designing a proper indexing strategy for what works best for your environment. There is no secret formula to define the correct indexes. An indexing strategy that works great for one system may perform poorly on another system.
Another aspect is that an indexing strategy is ever-evolving. Design and implement indexes for what your system needs at the present time. As your system evolves, so too must your indexes. Be careful defining indexes that your system does not currently use but may use later. This type of strategy often ends up in indexes not being used, but having to be constantly maintained.
Get Microsoft SQL Server 2012 Bible 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.