Can I Partition Any Table In Sybase?

1.	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 repartition tables to CHANGE the number of PARTITIONS. 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 repartition tables to change the number of partitions.

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 repartition tables to CHANGE the number of PARTITIONS.

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 repartition tables to change the number of partitions.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Bcp Only A Certain Set Of Rows Out Of A Large Table?
What Are The Main Advantages And Disadvantages Of Using Identity Columns?
Is There Any Disadvantage Of Splitting Up Your Application Data Into A Number Of Different Databases?
How Do You Tell The Data Time Of Server Started?
How Frequently You Defrag The Database?
What Are Constraints? Explain Different Types Of Constraints?
How Do You Force A Transaction To Fail?
How Do You Optimize A Select Statement?
How Do You Optimize A Stored Procedure?
What Are Advantage Of Using Triggers?