Stat Table vs Automate Gather Statistics
There are two distinct approach for statistic gathering in oracle :
Manual Stale statistics gathering
Automate statistic gathering (default)
I have two queries:
- Need to understand what should be the conditions to decide upon use of methods define above ?
- if we keep statistics in stat table and lock those statistics to be get used every time for particular db objects. what could be the conditions where this method can be use?
As per my understanding :
- Where data deletion/insertion and update is like OLTP systems and very frequent. we can use manual statistics gathering.
- & where data is not much changing and use just for reporting purpose just like data warehouse, we can use automate statistics gathering.
0