Answers

Question and Answer:

  Home  Sybase

⟩ Can I Partition Any Table in Sybase ?

No. You cannot partition the following kinds of tables:

1. Tables with clustered indexes (as of release 11.5 it is possible to have a clustered index on a partitioned table)

2. ASE system tables

3. Work tables

4. Temporary tables

5. Tables that are already partitioned. However, you can unpartition and then re-partition tables to change the number of partitions.

 148 views

More Questions for you: