Re: NewBie question: 9i query runs slower than same query on 8i?

paulhux174_at_hotmail.com wrote:
> Thanks for your replies, but maybe I didn't explain it well enough...
>
> The Oracle 9i database on another machine hasn't changed.
>
> The application hasn't changed.
>
> When I installed the 8i ODBC driver in my local box the query runs
> well.
>
> When I install 9i ODBC driver on my local box the query is 'about' 5
> time slower.
>
> To my thinking it must be the local ODBC driver configuration.
> I there some non-out-of-the-box configuration I would need to do.

You explained it well enough ... you need to listen better.

Reread the advice you were given ... and follow it.

Step 1 ... Explain Plans on both.

If you don't know how then www.psoug.org click on Morgan's Library
click on Explain Plan

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)