suzn cas
asked on
index maintenance - Sybase ASE
dears, I use reorg rebuild index to maintain indexes on table with data lock ,
but what can I use with allpages locking table? how to maintain its indexes, then update statistics??
kindly help
but what can I use with allpages locking table? how to maintain its indexes, then update statistics??
kindly help
Looks like locks issues, I would like to suggest increase the number of locks using sp_configure option parameter.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.