Post reply

Index fragmentation

  • August 9, 2012 at 1:34 am

    #280057

    In a particular table there were one million of records. Cluster and non cluster indexes were defined on that table. All History records have been moved to another history table except current thousand records only. Now average index fragmentation of the table is 60 %. If rebuild index result is same. how could it be reduced?

    How will it effect performance?

  • August 9, 2012 at 4:04 am

    #1523644

    what are the number of pages if it is less than 20 hopefully ignoreable.

    as you have reduced it to 1000 rows it is a smaller table now.

    Regards
    Durai Nagarajan

  • August 9, 2012 at 4:23 am

    #1523651

    Thanks for your reply. No of page is 5 Only.

  • August 9, 2012 at 4:30 am

    #1523654

    Hi,

    It would be better if we ignore the fragementation of indexes with less than 1000 pages

    Please refer below URL:

    http://connect.microsoft.com/SQLServer/feedback/details/244214/index-rebuild-doesnt-affect-fragmentation

    Hope the URL clarifies your doubt 🙂

    Thanks,

    Mohammed

  • August 9, 2012 at 4:45 am

    #1523661

    Hello ,

    hope 100 pages can go up to 200000 records, instead we can ignore till 500 pages.

    i have speciefied 20 pages to have the fragmentation to get reflected properly by system.

    Regards
    Durai Nagarajan

Viewing 5 posts - 1 through 4 (of 4 total)

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