Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: rebuild index timeframe

    Hi Gurus,

    Is there any way to estimate index rebuild on a large table. It will be helpful to inform user before rebuild that it will take xx hrs. is it possible pl??

    Thanks and Regards,
    Ram.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    No, the time will depend on various things e.g. Your table size (MB), Disk I/O speed, memory, sort buffers, CPU, etc.
    Best is to build an index on a sample to get an estimate e.g.
    select top 10000 * into sampletable from largetable
    Then build an index on sampletable
    If it takes 10 second then you can guess that 5000000
    will take 10*500=5000 seconds
    You can also look at the size of the table (data KB from sp_spaceused)
    If another_large_table is twice as big then it should take twice as long
    Note: Clustered (placement) indexes take much longer as all the data is copied to a new location.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •