Before you run reorg rebuild on a table:
Set the database option select into/bulkcopy/pllsort to true.
Determine if your table uses a datapages or datarows locking scheme
Make sure that additional disk space, equal to the size of the table and its indexes, is available.
To set select into/bulkcopy/pllsort to true:
1> use master 2> go 1> sp_dboption pubs2, "select into/bulkcopy/pllsort", true 2> go
Following a rebuild on a table:
Dump the database containing the table before you can dump the transaction log.
Distribution statistics for the table are updated.
All stored procedures that reference the table are recompiled the next time they are run.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
