Explain the way to select tables for partition in Sybase

Question

Explain the way to select tables for partition in Sybase?

Answer 1

You must partition heap tables which have large amounts of concurrent insert activity. Because, a heap table is a table, which no clustered index. Now here are some illustrations:

1. An "append-only" table to that every transaction should write
2. A tables which provide a history or say audit list of activities
3. A new table in which you load data along with bcp in. When the data is loaded in, then you can unpartition the table. It allows you to create a clustered index upon the table, or give other commands not permitted upon a partition table.