optmizer mode

hi there
i m working on oracle 9.2.0.1.0 win2k
optimizer mode is choose
none of the tables in the schema are analyzed
but after analyzing the entire schema the application n reports started
working slowly
in oem if u check any session the cache plan shows rule based but
by default in 9i if the optimizer mode is choose it is cost based
so cause of that i cant create new indexes as i will hav to analyze the
table then n that gives a prob
so plz help me on this
Received on Tue Feb 15 2005 - 04:34:50 CST