Post reply

theoritical size of an index

  • June 6, 2013 at 11:09 am

    #278684

    I have an index occupying almost 77 GB space on the drive which is 70 percent fragmented. I am trying to calculate the theoritical size of this index. This index is on field with data type bigint and with datetime field in included list. The table has 3.3 billion rows.

  • June 7, 2013 at 1:59 am

    #1621995

    muthyala_51 (6/6/2013)

    I have an index occupying almost 77 GB space on the drive which is 70 percent fragmented. I am trying to calculate the theoritical size of this index. This index is on field with data type bigint and with datetime field in included list. The table has 3.3 billion rows.

    Is the index 70% fragmented?

    The size of the index depends on the data type and the fill factor of the index.

    If the index is 70% fragmented - I would recommend that you rebuild the index - This should decrease the size of the index.

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

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