Sybase Question: Download Questions PDF
How Do I Choose Which Tables To Partition in Sybase?
Answer:
You should partition heap tables that have large amounts of concurrent insert activity. (A heap table is a table with no clustered index.) Here are some examples:
1. An "append-only" table to which every transaction must write
2. Tables that provide a history or audit list of activities
3. A new table into which you load data with bcp in. Once the data is loaded in, you can unpartition the table. This enables you to create a clustered index on the table, or issue other commands not permitted on a partition table.
1. An "append-only" table to which every transaction must write
2. Tables that provide a history or audit list of activities
3. A new table into which you load data with bcp in. Once the data is loaded in, you can unpartition the table. This enables you to create a clustered index on the table, or issue other commands not permitted on a partition table.
Download Sybase Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Does Table Partitioning Require User-Defined Segments in Sybase? | Can I Partition Any Table in Sybase ? |