Oracle
1Z0-882 · Question #66
1Z0-882 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
Which statement is true about the difference between HASH and BTREE INDEXES?
Options
- AHASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes
- BHASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE
- CHASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can
- DHASH indexes are much faster than BTREE indexes but can only be used for a single column.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.