Re: INDEX RANGE SCAN not used when View is used

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 16 Mar 2004 21:58:44 -0800
Message-ID: <1079503098.991919@yasure>

mcrn wrote:
> Hi all,
>
> I'm running oracle 8.1.6.0.0 and
> I got a situation here that doesn't make sense to me

Doesn't make sense to me either. Why would anyone be running on an obsolete and unpatched version of a database version for which the list of bugs is longer than the distance to Sedna?

Before thinking about anything else ... at least apply the appropriate patches to 8.1.6 to get the optimizer working.

After that you can worry about tuning. Realistically, upgrading to 8.1.7.4 should be the minimum. But 8.1.6.0.0 is inexcusable.

-- 
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 Tue Mar 16 2004 - 23:58:44 CST