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.
- Sybase Feature Request (to be added)
- ISUG Feature request