Hash cluster alternatives for non-clustered table - Oracle Clusters

Q.  What alternative does a hash cluster provide to a non-clustered table?
- Published on 27 Jul 15

a. Index
b. Index Cluster
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - Storing a table in a hash cluster is an optional way to improve the performance of data retrieval.

    - A hash cluster provides an alternative to a non-clustered table with an index or an index cluster.

    - With an indexed table or index cluster, Oracle locates the rows in a table using key values that Oracle stores in a separate index.

    - To use hashing, you create a hash cluster and load tables into it.

    - Oracle physically stores the rows of a table in a hash cluster and retrieves them according to the results of a hash function.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)