Re: Query improvement on 9.2.0.4

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 15 Jan 2004 08:24:00 -0800
Message-ID: <1074183767.537988@yasure>

James A. Williams wrote:

> Running on a 9.2.0.4 database. Its a vendor app that can't support CBO
> yet!
>

Your assumption that you are RBO because of the vendor is not valid. Oracle can still use CBO and may well be doing just that.

Tom Kyte - "Effective Oracle by Design" - See the note at the top of page 340.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Thu Jan 15 2004 - 10:24:00 CST