CHAPTER 1
Oracle Indexes
An index is an optionally created database object used primarily to increase query performance. The purpose of a database index is similar to 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 the 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 Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database 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.
