Sybase Question: Download Questions PDF
Can I Partition Any Table in Sybase ?
Answer:
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.
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.
Download Sybase Interview Questions And Answers
PDF
Previous Question | Next Question |
How Do I Choose Which Tables To Partition in Sybase? | What Is Table Partitioning in Sybase? |