Design and Indexing
You can greatly enhance performance by paying close attention to logical database design. The importance of design for performance (as well as in other areas) belies the often repeated notion that with a relational database system, you need to specify only what you want, not how to get it. The relational database is no smarter than your design.
Chapters 2 and 3 explain how to analyze your data and follow the normalization guidelines in order to wind up with a good, clean database design. You may remember from the discussion in these chapters that indexes speed retrieval considerably while slowing down data modification to some extent and that splitting tables for the purposes of normalization can slow the retrieval of data ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition 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.
