Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34

    Unanswered: Drawbacks of Cluster Index

    Hi All,

    What are the drawbacks/disadvantages of cluster index apart from following?

    -It will degrade the performance of DML (Insert, update and Delete) statement

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    That's a rather broad statement, and can be applied to any index, really. The trick is to quantify how much trade-off there is between having the index and not.

    Have you talked about page splits, as yet?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •