DEVFYI - Developer Resource - FYI

When can hash cluster used?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

699.When can hash cluster used?

Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.

(Continued on next question...)

Other Interview Questions