"Jim Poe" <jbpoe_at_pacbell.net> wrote in message
news:MPG.179b347cf619144989683_at_news.sf.sbcglobal.net...
> I tried it without the Upper function and it is still
> generating the same plan and still taking 10 seconds.
Can you verify whether it is faster if it does use the index i.e. by using
an index hint. This may not help matter that much if you don't have access
to the source of the app but it will confirm whether your theory - that
index access is faster - holds true. I can't actually read from your post
what is cost and what the cardinality is in the explain plan.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Jul 15 2002 - 02:56:37 CDT
