Oracle
1Z0-882 · Question #66
Which statement is true about the difference between HASH and BTREE INDEXES?
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.
MySQL Optimization and Indexes
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.
Topics
#HASH index#BTREE index#index types#equality comparisons