Chapter 13: Object Tuning

---

Overview

There are two layers to object physical tuning. The first layer allows for special behavior applied to objects such as tables and indexes. These special behaviors will be covered in this chapter. The second layer is explicit block and extent level tuning within objects. Explicit block and extent level tuning is what I like to call low-level architecture and will be covered in Chapter 14.

This chapter looks at object-level physical tuning. What is object-level physical tuning? This subject encompasses changes to an object, such as a table, which involve changing the underlying physical structure without necessarily affecting block structure. This chapter is split into the different objects such as tables, indexes, and sequences. Much of the detail for many object types is covered in the first section on tables. Each subsequent section is expanded to cater for details specific to the different object types.

---