Function based indexes need to be analyzed in order to be used. Verify
your statement with an explain plan output.

Steve Siebenaler
Cincinnati, Ohio USA



-----Original Message-----
From: Geluvu 74 [mailto:[Email Address Removed]
Sent: Friday, January 31, 2003 5:44 AM
To: LazyDBA.com Discussion
Subject: Can someone clarify this?...


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page