nerdexam
Oracle

1Z0-882 · Question #66

Which statement is true about the difference between HASH and BTREE INDEXES?

The correct answer is C. HASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can. https://devcenter.heroku.com/articles/postgresql-indexes

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.

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    12% (4)
  • C
    82% (28)
  • D
    3% (1)

Explanation

https://devcenter.heroku.com/articles/postgresql-indexes

Topics

#HASH index#BTREE index#index types#equality comparisons

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-882 Practice