类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
哪位大哥详细介绍sybase关于锁的问题，或者提供些资料也可以，先谢谢了
网友回答：
A locking scheme is a table attribute defining which data
associated with the table is locked.
n There are three locking schemes:
• Allpages locking (APL)
• Datapages locking (DPL)
• Datarows locking (DRL)
n Indexes may or may not sort table data and/or maintain it in
index order.
• APL clustered indexes sort table data in index order, and
maintain table data in index order.
• DOL clustered indexes sort table data in index order. They
attempt to maintain data in index order, but they do not
guarantee it.
• APL and DOL nonclustered indexes do not sort table data in
index order.
n Except for APL clustered indexes, all indexes have a distinct
leaf level.
n When choosing a locking scheme:
• Try the Allpages locking scheme first.
• If there are contention problems, you may want to try the
Datarows locking scheme next.
• Try the Datapages locking scheme last.