Advertisement

Indexes

  • Sean Dillon
  • Christopher Beck
  • Thomas Kyte
  • Joel Kallman
  • Howard Rogers

Abstract

The appropriate use of indexes can turn an otherwise sluggish and recalcitrant application into a highly responsive and productive business tool. Unfortunately, the converse is also true. Scattering inappropriate indexes around an application without careful thought is perfectly capable of turning it into a lumbering behemoth that’s not much use to anyone. Working out whether an index is appropriate, and how best to create it if it is, is something of an acquired skill — which this chapter will help you to acquire. We’re first going to look at what goes on inside Oracle when you opt to create a simple one, and then use that information to see how the additional index features available in recent Oracle releases can best be harnessed. During the course of the chapter we’ll look at:
  • What are indexes

  • Indexes in Oracle

  • Knowing the value and the cost of indexes

  • Indexing multiple columns, key compression, skip scanning, and reverse key indexes

  • Some myths of indexing

  • Function-based indexes

  • Bitmap and Bitmap Join indexes

Keywords

Leaf Node Unique Constraint Execution Plan Branch Node Full Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Apress 2002

Authors and Affiliations

  • Sean Dillon
  • Christopher Beck
  • Thomas Kyte
  • Joel Kallman
  • Howard Rogers

There are no affiliations available

Personalised recommendations