Hi,
There ist enough information to give you a proper answer. But (unfortunately) I see a misconception in your "reasons".
a lot of people "blame" "old" statistics. The statistics do not have to be "new", keep in mind that a couple of minutes after they have been calculated they are already "old".
Statistics have to be acurate and representative, and some times "false".
Usually the reason is lack of index.
In any case, you must
1.- find out what queries are doing those table scans
2.- find out if the queries make sense (if you need 99% of the rows in the table a FTS makes sense, if you want one row, it does not make sense)
3.- if an index is desired (second case), does an index already exist?
a.- no, then create one
b.- yes, then analyze why it is not taken. This step is the one a lot of people misses. it might be due to statistcs (why?), to a bug (which one?)
Hey Sundar,
do you face any performance issues after upgrade? If not - you have no problem: "Compulsive Tuning Disorder".
Regards
Stefan
P.S.: IMHO EWA is for trash can in 99% of the cases.
Add comment