Semantic partitioning is a licensed feature. To enable semantic partitioning at your licensed site, enter:
sp_configure ‘enable semantic partitioning’, 1
Round-robin partitioning is always available, and it is unaffected by the value of enable semantic partitioning.
Enable semantic partitioning to perform commonly used administrative and maintenance operations such as:
Creating and truncating tables – create table, truncate table
Altering tables to change locks or modify schema – alter table
Creating indexes – create index
Updating statistical information – update statistics
Reorganizing table pages to conform to clustered indexes and best use of space – reorg rebuild
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
