O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14

Indexing Strategies for Query Optimization

SQL Server applications are all about executing queries, so you need to do everything you can to make sure that those queries execute as quickly and efficiently as possible. Because SQL Server is a shared service with multiple users, tuning an application from the perspective of one user is not enough. You must also consider the impact that many users accessing data concurrently will have on performance.

Tuning a SQL Server application is a cost-based approach where you will have to evaluate the aggregate costs of the resources consumed and attempt to mitigate those costs by using optimization techniques including indexing, archiving, and load balancing to name a few. While there are many ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required