All I am wondering why the following gather stats command will take 24hrs on serverA however if i export the table and import it (including indexes) to serverB the stats are collected in 10 minutes.
ServerA and Server are identical vm's on the same metal box
ownname => 'SIEBEL',
tabname => 'S_OPTY',
block_sample => FALSE,
method_opt => 'FOR ALL COLUMNS size SKEWONLY',
granularity => 'ALL',
cascade => FALSE,
degree => DBMS_STATS.DEFAULT_DEGREE);
also with the above stats should index stats be run also?