Post reply

Index Rebuild Question?

  • September 18, 2012 at 3:36 am

    #281900

    Hi All,

    I am doing some R&D on Indexes.

    I have a table as follows:

    CREATE TABLE SINGLEINTVARCHAR

    (

    ID INT IDENTITY(1,1) PRIMARY KEY

    ,VARCHARNAME CHAR(5)

    )

    and i have inserted records 1790.

    Now when i check the fragmentation of clustered index it is showing 50 so i have applied the REBUILD option but still it is showing 50 percent only.

    Can any one tell me why i am not able to reduce this fragmentation level?

    🙂

  • September 18, 2012 at 4:24 am

    #1538989

    Because the table's too small. The table comprises 2 pages perhaps. The general advice on where you worry about fragmentation is around 1000 pages.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply