Home » Databases » Sybase » ASE » Reorg ‘with time=’ – counter intuitive

Reorg ‘with time=’ – counter intuitive

The "with time = " feature of reorg currently will loop on the table until the time limit is reached. This is in no way intuitive and serves very little in functionality for smaller tables. Keep in mind that most reorg operations are scripted and aren’t intelligent enough to disable the ‘with time =’ for small tables.

Feature request #2 (design bug):

reorg ‘with time =’ should be the maximum possible time that a reorg can take. No looping should be performed unless ‘with time = 10, loop’ or similar is explicitly stated.


Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *


Facebook login by WP-FB-AutoConnect