By using the _______ , you can able to reduce access time for joins.

Options
- Index
- Cluster
- Control file
- Data file

CORRECT ANSWER : Cluster

Discussion Board
Oracle Cluster

By using the cluster, you can able to reduce access time for joins. Oracle can perform a cluster join only for an equi join that equates the cluster key columns of two tables in the same cluster. In a cluster, rows from both tables with the same cluster key values are stored in the same blocks, so Oracle only accesses those blocks.

Prajakta Pandit 03-2-2017 06:11 AM

Write your comments


Enter the code shown above:

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


Related Content

Advertisement
 
▲