The benefit of reverse key indexes is that they

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The benefit of reverse-key indexes is that they enhance performance in Oracle Parallel Server environments because this type of index should be created to spread the distribution of index upon across the index tree. Incorrect Answers: A: B-tree index try to keep as much data as possible in the leaves of the index tree, minimizing amount of levels in index, this type of index does not distribute index upon the index tree, as reverse-key index does. B: Bitmap indexes are stored not as all other indexes in Oracle with the root-branch-leaf structure. The bitmap index stores an entry containing each distinct value, the start and the end ROWID to indicate the range of ROWIDs in this table, and a long binary string with as many bits as there are rows in the table. D: Function-based indexes is not used to distribute index upon across the index tree. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 417-422 Chapter 9: Managing Database Objects I QUESTION 17: Which statement about rebuilding indexes is true?...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online