Re: Same SQL in 9i vs 7.3.4.5 takes long time

On Wed, 19 Nov 2003 21:00:25 +0000, Don Seiler wrote:

> Doing application testing for an upgrade to Oracle 9.2 from 7.3.4.5.  One
> query that finishes almost instantaneously on 7.3.4.5 takes at least a
> couple of minutes on 9.2.

Hmm just upgraded the db to 9.2.0.4 (was 9.2.0.1) and the query itself ran
great.  Going to have QA staff do actual app testing in the morning but
perhaps 9.2.0.4 fixed whatever the issue was.