Originally posted by thg
marist89,

I just realized that the 'explain plan' uses the statistics from 'analyze table' & 'analyze indexes'. Does that mean if I don't ran the 'analyze...' commands frequently, my query will become very slow?

Not necessarily. If the distribution of your data does not change or if the volume does not change, you don't have to analyze as frequently. However, if your data changes rapidly, you should analyze more frequently.


Here is one of the 'explain plan' results from my query, is my query optimized?
Depends. Sometimes a Full Scan is preferable to an index hit. If you have indexes on the tables that are full scanned, I would force the index usage and see if the response time decreases.