CHAPTER 7Effective Schema Design
Your application will live and die based on its physical implementation. Choose the wrong data structures, and performance will be crippled and flexibility limited. Choose the correct data structures, and you could have great performance. In this chapter, we will look at some of the things you need to consider when designing your schema. Then we will focus on table types, some useful index types, and finally, compression.
Fundamental Schema Design Principles
In this section, we’ll consider some of the fundamental approaches that you should adopt when designing your schema. We’ll cover integrity checking, datatype selection, and optimization for queries.
Let the Database Enforce Data Integrity
We touched on this ...
Get Effective Oracle by Design 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.