Usage-Driven Database Design: From Logical Data Modeling through Physical Schema Definition

© George Tillmann 2017

George Tillmann, Usage-Driven Database Design, 10.1007/978-1-4842-2722-0_13

13. Customization: Enhancing Performance

George Tillmann¹ 

(1)Ship Bottom, New Jersey, USA

It is a bad plan that admits no modifications.

—Publilus Syrus

An expert is a person who has made all the mistakes that can be made in a very narrow field.

—Niels Bohr

For a number of crucial reasons, enhancing the performance of the database design is done last. First, any performance considerations need to wait until the database design is well understood. This ensures that critical functional components are completely identified, included, and documented before any changes are made to the database design. If you start modifying the design before properly documenting ...