Re: Indexes ignored

Hi Joe,

Also, could you post the definition of the OFFICE_PHN_SRCH view (assuming it is a view).

If the NBR column is unique, then in theory it should only be returning one row. However, if the view is joining a whole bunch of tables together (which I should have picked up earlier) then well anything could be happening. You could be using a complex view but only be selecting columns from the one table (seen that before). Not good. Need to see the query inside the view to get the complete picture.

Regards

Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d328035$0$227$ed9e5944_at_reading.news.pipex.net...
> "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 - 05:42:31 CDT