Sybase Certification Interview Question:

Explain What are some ways to reduce last data page lock contention for inserts?
(Choose 3)
A. alter the table to use the Datarows locking scheme
B. alter the table to use the Datapages locking scheme
C. partition the table
D. create a clustered index on a random key
E. increase the server configuration for the number of locks
F. increase the server configuration for the deadlock checking period

Submitted by: Administrator

A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key
Submitted by: Administrator