Running reorg rebuild indexname on a large table may take a long time. Periodic status messages display; starting and ending messages are written to the error log and to the client process executing reorg. In-progress messages display only to the client.
A status reporting interval is calculated as either 10 percent of the pages to be processed or 10,000 pages, whichever is larger. When this number of pages is processed, a status message is printed. Therefore, no more than 10 messages are printed, regardless of the size of the index. Status messages for existing reorg commands are printed more frequently.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
