I want to know what should be the ideal Frequency for Analyzing tables in a schema. Database size 1GB.
Currently the frequency is set to 7 days, it takes around 40 mins to complete. Data volume is not huge.
Please let me know how can I optimize it?
What all options and to what values they should be set for DBMS_STATS.GATHER_TABLE_STATS.