How Do I Choose Which Tables To Partition in Sybase?
Submitted by: AdministratorYou 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Sybase Job Interview Questions And Answers
Top Sybase Questions
| ☺ | What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase? |
| ☺ | How to pad with leading zeros an int or smallint in Sybase? |
| ☺ | Explain about the features of Sybase IQ? |
| ☺ | How can I execute dynamic SQL with ASE in Sybase? |
| ☺ | Explain about Power Designer Data modeling software? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
