Hello,
I'm running "reorg rebuild <table> with online" and "reorg rebuild <table> <index> with online" (one after the other) on a table with 100+Mio rows in ASE 15.7 Sp134.
Although the documentation states that there is only a short duration of table lock on the target table at the beginning and at the end of this process, I wonder if there is any chance that other processes (incl. prepared statements) still get blocked somehow (latch contention, systables, xlog).
Why does the documentation say "Sybase® recommends that you run reorg rebuild ...online when the table’s transaction load is relatively low" ?
What is the best practice approach to reorganize huge tables/indexes if this process is prone to locks (resume option is not available for reorg rebuild)?
Thanks,
Matthias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.