Chapter 3: Balancing Performance and Correctness

In This Chapter

arrow Designing a database

arrow Maintaining database integrity

arrow Avoiding data corruption

arrow Speeding data retrievals

arrow Indexes

arrow Data structures

arrow Reading execution plans

arrow Optimizing execution plans

arrow 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 a database for the highest possible performance ...

Get SQL All-in-One For Dummies®, 2nd 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.

Start your free trial