1.

Explain table partitioning in Sybase.

Answer»

Table partitioning is a FEATURE that creates multiple CHAINS for a SINGLE table. The fundamental purpose of this feature is to improve the performance of inserts to a table by reducing contention in the last page of the chain. This feature can improve the performance by allowing USERS to distribute a table's I/O over multiple DATABASE devices.



Discussion

No Comment Found