Chapter 3
Balancing Performance and Correctness
IN THIS CHAPTER
Designing a database
Maintaining database integrity
Avoiding data corruption
Speeding data retrievals
Working with indexes
Determining data structures
Reading execution plans
Optimizing execution plans
Improving performance with load balancing
There’s a natural conflict between the performance of a database and its correctness. If you want to minimize the chance that incorrect or inappropriate data ends up in a database, you must include safeguards against it. These safeguards take time and thus slow down operation.
Configuring ...
Get SQL All-in-One For Dummies, 4th 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.
