dbms_stats.gather_schema_stats

[dbasan]

Table-Gathering statistics for a table,will touch its indexes also ?or need to do it seperatly.

No (in general - need to set in query)
Yes (in your case)

[malay_biswal]

I pointed out out frequency beacuse, if you run gather stats job weekly once and still face performance problems and after analyzing it seemsexplain plan is not good enough because of volume of data updated or inserted, then you need to gather stats more than once a week.

Hope this clarifies.

[PAVB]

are you changing more than 20% of your data a week?