The statement I used is below:
exec dbms_stats.gather_table_stats('user1',table1',null,10,false,'for all columns',null,'ALL',TRUE);
This should gather global and partition level stats. But is seemed to be only the latter is gathered.
|
Results 1 to 3 of 3
Thread: differences in num_rowsThreaded View
|
Click Here to Expand Forum to Full Width |