12.1. Understand Index Architecture
An important component of planning appropriate indexes is understanding the underlying storage architecture. Based on the way data is stored in SQL Server, some types of queries will lend themselves to certain index structures and, in some cases, perhaps no indexes at all. In the following sections, we will describe some of the index architectures you will see in SQL Server and how to use this knowledge of index architecture to plan your own index implementation.
12.1.1. Understand Index Storage
You may have heard it said that the natural state of the world is chaos. If that is true about the world in general, it must be doubly so for a database. Without any effort at maintaining structure and order, data ...
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.
