Hi,
I had a query which was running for 5 hours. I had posted couple of days
back. After that I created a function based index, still the query plan was
not using newly created indexes. The performance was same. Y'day i thought I
will just try issuing
alter session set query_rewrite_enabled = true before executing that query.
The performance was great & response time came to 19 seconds.
Infact today morning also i tried it wroked fine. But, now i thought i will
try once more, so i followed same steps, executed alter session command and
issued that query. Now again it is taking 6 hours. Between the time it
executed fine and now I haven't made any changes. Can one someone explain me
how is this possible. I referred few docs it says this setting query rewrite
enabled is wrt materialized views. Then how come the moment i enabled this
my query worked fine. I have explainplan output stored for all these
instance. The query plan which it was using was different morning.
Thanks

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Oracle LazyDBA home page