Post reply

Can we run index rebuild in standard edition

  • September 21, 2014 at 9:56 pm

    #296580

    Hi all,

    Can we run index rebuild in standard edition 2005

    can we create a maintenanace plan in standard edition 2005 will this cause performacne issue

    Thanks

    Naga.RohitKumar

    Thanks
    Naga.Rohitkumar

  • September 21, 2014 at 10:13 pm

    #1746935

    Can we run index rebuild in standard edition 2005

    Yes. They will be offline index rebuilds, meaning that changes to the index/table could be blocked during the operation.

    can we create a maintenanace plan in standard edition 2005 will this cause performacne issue

    As noted above blocking will occur during the index rebuild of each index/table. Overall performance may be seen since these involve I/O operations. You will generally do these during your maintenance windows for the server or application.

    While maintenance plans are the easier way to implement index maintenance, and are better than nothing, it would be advised to look at using customized scripts. The maintenance plan offers little customization as to which indexes actually need to be rebuilt or not. Ola Hallengren offers the most used scripts for index and statistics maintenance of a database.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • September 22, 2014 at 7:56 pm

    #1747276

    suppose if we need to Rebuld or Reorg index how will we come to know which one to select and at which sitiuation can you please ellobarate

    Thanks
    Naga.Rohitkumar

  • September 22, 2014 at 8:26 pm

    #1747278

    naga.rohitkumar (9/22/2014)

    suppose if we need to Rebuld or Reorg index how will we come to know which one to select and at which sitiuation can you please ellobarate

    As with the other question you asked on the other post about indexes and because these are starting to sound a whole lot like interview questions or "university" questions, you really need to buckle down and spend some time in "Books Online" so that you truly understand the answers to your questions.

    For this one, look up "Alter Index" and then do a search for "REBUILD". Also take a look at the script in the examples, study it, and learn from it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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