You can create a clustered index on a partitioned table if the following conditions are true:
The select into/bulkcopy/pllsort database option is set to true, and
As many worker threads are available as the number of partitions.
Before creating a global index on a round-robin–partitioned
table, make sure the server is configured to run in parallel.
To speed recovery, dump the database after creating the clustered index.
See a System Administrator or the Database Owner before creating a clustered index on a partitioned table.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
