Chapter 8. Tuning the Schema
A key component in creating a high-performance database or improving one that is performing inadequately lies in the schema. The schema refers to both the general and specific design of a database. General aspects include items such as normalization and database style (OLTP, OLAP). Specific aspects include items such as data types, foreign key relationships, table definitions, and so on. This chapter serves as a guide, describing the techniques and methodologies addressing both areas.
Get Professional SQL Server® 2005 Performance Tuning 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.
