sybase 中经常锁表该怎么解决?

chj3851

免费乐捐，感谢支持

环境:sybase 12.5

这个库中的 sp_depends XSJL 比其他地方出现的信息多出来下面的一些东西.不明白是什么意思?请高手指点?

Dependent objects that reference all columns in the table. Use sp_depends on each column to get more information.
Columns referenced in stored procedures, views or triggers are not included in this report.
 
Column                         Type                    Object Names or Column Names                                
------------------------------ ----------------------- ------------------------------------------------------------
JLBH                           index                   PK_XSJL (SKTNO, JLBH)                                       
JYSJ                           index                   XSJL_JYSJ (JYSJ)                                            
JZRQ                           index                   XSJL_JZRQ (JZRQ)                                            
SKTNO                          index                   PK_XSJL (SKTNO, JLBH)                                       
SKY                            index                   XSJL_SKY (SKY)                                              
XSJE                           default                 XSJL_XSJE_1849773647     

估计是表建的有问题。打算重新建立.但是上面的是什么意思呢?                                   

flybean

translate it into chinese first

delstat

SKTNO                          index                   PK_XSJL (SKTNO, JLBH)   
这行代表你用SKTNO这个字段做了外键，其他的index型，代表的也是你建的索引，你可以看看你自己的表结构