cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase ASE maintenance - update stats or reorg rebuild

robnye
Member
0 Kudos

Hello ,

I am new to Sybase (previous oracle dba experience).

I have inherited, some maintenance scripts, which take hours to run = 12 hours (85GB database), I have looked at the scripts and there appears to be duplication in what they are doing
ie
script 1
update index statistics acct_class
update index statistics acct_class_type

script 2
reorg rebuild acct_class acct_class_prim
reorg rebuild acct_class acct_class_sec
reorg rebuild acct_class acct_class_slct
reorg rebuild acct_class_type acct_class_type_prim
reorg rebuild acct_class_type acct_class_type_sec
reorg rebuild acct_class_type acct_class_type_slct

my question is .... if I am (reading the manuals correctly), If I 'reorg rebuild' a table and its index, then an update statistics is not required

is this correct?

Accepted Solutions (0)

Answers (0)