Link to home
Start Free TrialLog in
Avatar of suzn cas
suzn casFlag for Syrian Arab Republic

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
Avatar of sathish GT
sathish GT
Flag of India image

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 TRIAL
Members 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.