This preview shows page 1. Sign up to view the full content.
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.
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
Which statement about rebuilding indexes is true?...
View Full Document
- Fall '09