CHAPTER 9Table Structures and Indexing

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the engineer, the glass is twice as big as it needs to be.

—Unknown, http://www.boardofwisdom.com

When it comes to tuning your database structures, you must maintain a balance between doing too much and doing too little. Indexing strategies are a great example of this. If you don't use indexes enough, searches will be slow, as the query processor could have to read every row of every table for every query. Use too many indexes, and modifying data could take too long, as indexes have to be maintained. Balance is the key, kind of like matching the amount of fluid to the size of the glass.

Everything we have done so far ...

Get Pro SQL Server 2008 Relational Database Design and Implementation now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.