Chapter 8

Database Design and Performance Tuning

Abstract

This chapter looks at practical design choices that can impact the performance of a database. Topics include indexing, clustering, horizontal partitioning, and vertical partitioning.

Keywords

database indexes
database clustering
database partitioning
horizontal partitioning
vertical partitioning
How long are you willing to wait for a computer to respond to your request for information? 30 seconds? 10 seconds? 5 seconds? In truth, we humans are not very patient at all. Even five seconds can seem like an eternity, when you are waiting for something to appear on the screen. A database that has a slow response time to user queries usually means that you will have dissatisfied users.
Slow response ...

Get Relational Database Design and Implementation, 4th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.