O'Reilly logo

Pro Oracle Database 11g Administration by Darl Kuhn

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

C H A P T E R  8

images

Indexes

An index is an optional database object that is primarily used to increase performance. These objects are defined on a table and one or more columns. A database index functions similarly to an index in the back of a book. A book index associates the information of interest with a page number. When you're locating information in a book, it's usually much faster to inspect the index first, determine the page number, and then turn to the desired page. If there were no index, you would have to inspect every page of the book to find information.

An Oracle index is similar to a book index in that it stores information about ...

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