How Do I Choose Which Tables To Partition in Syb

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How Do I Choose Which Tables To Partition in Sybase?

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.

(Continued on next question...)

Other Job Interview Questions

• Explain about ETL data integration software?
• Explain about Sybase 365?
• Give the benefits of Data integration suite?
• Optimizing your Identity setup for performance and maintenance in Sybase
• Is it possible to do dynamic SQL before ASE 12 in Sybase?
• On what platforms is ASA supported?
• What applications is ASA good for?
• Why am I running out of locks on the replicate side in Sybase ?
• Optimizing your home grown Sequential key generating process for any version of Sybase
• Is the Identity the equivalent of Oracles auto-sequencing in Sybase?
• More...