Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    40

    Unanswered: Index Ratio Cluster

    Hi,

    I have a problem with index.
    I am running reorg rebuid on a particular table on every week, but still the index cluster ratio is 0.4 and query is very slow

    indly suggest me what can be done to rectify..


  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Try drop and recreate the clustered index. A reorg rebuild of a clustered index doesn't sort your data.

Posting Permissions

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