top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the disadvantages of clusters in Oracle?

+1 vote
726 views
What are the disadvantages 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

+2 votes
 
Best answer

The time for Insert increases.

answer Dec 18, 2014 by Arun Gowda
0 votes

Disadvantages:

(1)It takes longer to update records if only when the fields in the clustering index are changed.
(2)Avoid clustering index constructions where there is a risk that many concurrent inserts will happen on almost the same clustering index value

answer Dec 17, 2014 by Manikandan J
...