Tables to Partition in the Sybase

Question

Explain how do I choose which Tables to Partition in the Sybase?

Answer 1

You must partition heap tables which encompass large amounts of concurrent insert activity. (Heap table is a table with no clustered index.) Here are some illustrations:

a) An ‘append-only’ table to which each and every transaction should write.

b) Tables which provide a history or audit list of actions.

c) A new table to which you load data with bcp in. Once the data is loaded in, you can impartation the table.

This allows you to make a clustered index on the table or issue other commands not permitted on the partition table.