CHAPTER 8
Indexes
An index is an optionally created database object used primarily to increase query performance. The purpose of a database index is similar to that of an index in the back of a book. A book index associates a topic with a page number. When you’re locating information in a book, it’s usually much faster to examine the index first, find the topic of interest, and identify associated page numbers. With this information, you can navigate directly to specific page numbers in the book.
If a topic only appears on a few pages within the book, then the number of pages to read is minimal. In this manner, the usefulness of the index decreases ...
Get Pro Oracle Database 12c Administration, Second Edition 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.
