It also seems from the snapshot that most of bigger tables (tables with large page counts) are not indexed and they are heaps. Now for this if you see page count is 104,29 all very less ,again i dont think rebuild will have any significant affect I would like to take this value upto 500.I have seen OP posting even if i rebuild index index fragmentation is not gone.1000 can also be considered in some case as pointed out by Latheeshįor example from the above snapshot, indexid 3 on objectid 48719226 is a good candidate fro index rebuilds. If the page counts are less than 10 there is no need to do index rebuild or reorganize it wont affect at all.įor index rebuilds we should target the indexes which are more than 30% fragmented and the page count is greater than 10. If the page counts are less than or equal to 10 the even though the fragmentation is above 30%, Index Reorg will work. While seeing the Percent of Fragmentation, we also need to look at the page counts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |