In Sybase illustrates the term Table Partitioning

Question

In Sybase illustrates the term Table Partitioning?

Answer 1

Table partitioning is a procedure which creates numerous page chains for a single table. The primary reason of table partitioning is to enhance the performance of concurrent inserts to a table through reducing contention for the final page of a page chain.

Partitioning can also potentially enhance performance by making this possible to distribute a table's I/O over numerous database devices. There page contention for Inserts By default, Adaptive Server Enterprise stores a table's data within one double-linked set of pages termed as a page chain. When the table does not have a clustered index, Adaptive Server Enterprise makes all inserts to the table into the final page of the page chain.
While a transaction inserts a row in a table, Adaptive Server Enterprise holds an exclusive page lock on the final page while this inserts the row. If the current final page becomes full, Adaptive Server Enterprise allocates and links also a new last page.

As multiple transactions attempt to insert data in the table at the same instant, performance problems can happen. Only one transaction at a time can acquire an exclusive lock on the last page, therefore other concurrent insert transactions block each other.