Note

Index design is often considered part of physical database design. Because index design guidelines and the impact of indexes on query and update performance are covered in detail in Chapter 34, “Data Structures, Indexes and Performance,” this chapter does not discuss index design. It focuses instead on other aspects of database design and performance.

Get Microsoft® SQL Server 2008 R2 Unleashed 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.