O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Indexes

Database performance can be greatly affected by the proper use of indexes. They are one of the first objects you should investigate when encountering performance problems. However, you should remember that placing an index on a column may not necessarily provide the desired remedy. In those cases, you will commonly need to explore other performance tools.

Indexes are primarily used for two reasons:

  1. To ensure the uniqueness of the indexed column’s values

  2. To enhance performance

An index is an ordered set of records that correspond to records in a table. The index record consists of a column that relates to a corresponding column in the associated table. Each index record also has a rowid value, which is the location of the desired table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required