Hi All, i would like to know if it is possible toI suspect you're using 10g. As a starting point to your question, the following item from my blog may be helpful.
generate statistics via dbms_stats without generating
any histograms. I know Oracle probably knows better
than i do, but it is generating a hell of a lot that
i do not think are required?
It's a fairly brutal change, though and doesn't produce any histograms at all. So some of your plans are likely to change for the worse because they need histogram help. You ought to test the impact of the change on a copy of the database before implementing it on production.
method_opt => 'for all columns size 1'
Finally i have another issue where a user isThis is a fairly common threat with sequence of time-based columns. The highest value stored keeps increasing, so the "high_value" statistics goes out of date, and the optimizer thinks you are asking for data that can't possibly exist and does something silly.
generating reports using a date range, once the range
entered exceeds the what is recorded in the
statistics the explain plan is ignored and the report
We have just migrated one of our production databaseAs it says in the blog -
from 9iR2 32 bit(Windows) to 10gR2 64bit (Linux).
We don't use 'method_opt' parameter. The syntax was
used to analyze the table in 9i. What modification
should I made to get similar execution plan that I
was getting in 9i with same syntax?