Chapter 3. Optimizing Storage Structures

In this chapter, we will cover:

  • Avoiding row chaining
  • Avoiding row migration
  • Using LOBs
  • Using index clusters
  • Using hash clusters
  • Indexing the correct way
  • Rebuilding index
  • Compressing indexes
  • Using reverse key indexes
  • Using bitmap indexes
  • Migrating to index organized tables
  • Using partitioning

Introduction

In the previous chapter, we saw how to design an application which performs well (or has less chance to perform badly) by applying some simple rules of thumb, namely, connection management, reusable code, reducing requests to the database, schema denormalization, and the use of dynamic SQL.

In this chapter, we will look at some structures available in Oracle databases that store data and improve the access time—that is, ...

Get Oracle Database 11gR2 Performance Tuning Cookbook 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.