June 6, 2013 at 11:09 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy