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 Wed Jan 08 2003 - 00:29:15 CST
