Re: Query optimizer in Oracle 7.3.4

From: Cesar Otero Souto <cotero_at_most.com.ar>
Date: Wed, 08 Jan 2003 10:08:48 +0500
Message-ID: <avh6mu$hoo3@pen6.pen.k12.va.us>

Sorry, you are right W.L

On Tue, 07 Jan 2003 22:29:15 +0000, W.L wrote:

> hi, Oracle 7.3.4 uses RBO.
> SO FORGET THE STATS.
> MAY BE SOME INDEXES ARE MISSING OR
> MAYBE YOU HAVE MORE INDEXES ON THE TABLE INVOLVED IN THE QUERY.
>
>
> "ronia" <cotero_at_most.com.ar> wrote in message
> news:avffj1$hoo2_at_pen6.pen.k12.va.us...

>> Perhaps the statistics are diferent between both databases.
>>
>> On Tue, 07 Jan 2003 20:33:40 +0100, Aad Aldus wrote:
>>
>> > I have two Oracle 7.3.4 databases of about 1 GByte of data on a

> WindowsNT

>> > platform. The database are installed on a separate machine and contain

> the

>> > exactly the same data.
>> >
>> > I have a specific query that runs on one database in 10 sec and on the

> other

>> > database about 4 minutes.
>> >
>> > Both hardware specifications (CPU, disk, memory, Oracle memmorysettings,
>> > users logged in) are the same.
>> >
>> > Does anyone have an idea how this is possible or has a suggestion what

> to

>> > check.
>> >
>> > Thankx in advance.
>> > Aad
>>

Received on Tue Jan 07 2003 - 23:08:48 CST