Analyze partition table
Hello,I have a GL table(F0911) with range partition based on gldate and 20 indexes are there.the table size of F0911 is 85.414 GB and record count is 54118089 rows.
out of following option,which is the recommend analyze table with less elapsed time.
analyse table crpdta.f0911 compute statistics; -----------time consuming
or
analyse table crpdta.f0911 estimate statistics sample 20 percent;-
or
analyze each partition like
exec dbms_stats.gather_table_stats('CRPDTA','F0911','F0911_2004');
exec dbms_stats.gather_table_stats('CRPDTA','F0911','F0911_2005'); and so on
please advise
0