• SQLnbe (8/8/2014)


    Hey guys, sorry I'm a bit late on this but I had a question in regards the Online re-indexing in Enterprise. Does the ONLINE=ON completely eliminate the possibility of Table Locks when the process is running or does it just lower the % of that?

    Thanks 🙂

    Maybe you should open a new thread for that? But the answer is no. Still some locks are needed but the operation is less intrusive.

    Grab a cup of coffee and read this: How Online Index Operations Work