top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the advantages of clusters in Oracle?

+1 vote
461 views
What are the advantages of clusters in Oracle?
posted Dec 17, 2014 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
 
Best answer

Access time reduced for joins.

answer Dec 18, 2014 by Arun Gowda
0 votes

Clustered index

Advantages:

(1)Search results are quicker when records are retrieved by the cluster index
(2)other indexes that use fields that are a part of the cluster index might use less data space

answer Dec 17, 2014 by Manikandan J
...