Re: MY DATABASE IS SO SLOW

From: <pcucciolo_at_hotmail.com>
Date: Wed, 09 Dec 1998 09:49:46 GMT
Message-ID: <74lh3q$mae$1@nnrp1.dejanews.com>

Try whit

 select '98',data2.fare,data2.value,data2.class,names.n_desc,  count(data2.fare), sum(data2.numbers) from  data2,names
 where names.n_key=data2.class and class >'0' and  data2.key in (select data1.key from data1 where

                data1.year='98' and
                data1.company='33')

 group by '98',data2.fare,data2.value,data2.class,names.n_desc;

Optimizer is set to cost Based a ALL_ROWS? And have you analyzed tables data2, names and data1?

the query is the same only if data2.key is the primary key and data1.key is the primary key.

In article <01be21f8$d6c519c0$1401a8c0_at_test>,   "Michael Wagner" <wagner_at_eurolab.at> wrote:
> I have a database with approx 3.500.000 entrys with 110 byte/set and the
> database grow i this year up to 80.000.000 entrys. If i make a query on the
> 3.500.000 entrys it needs 1 hour before i get the result.
>
> select data1.year,data2.fare,data2.value,data2.class,names.n_desc,
> count(data2.fare), sum(data2.numbers) from
> data1,data2,names
> where data1.key=data2.key
> and names.n_key=data2.class and class >'0' and data1.year='98' and
> data1.company='33'
> group by data1.year,data2.fare,data2.value,data2.class,names.n_desc;
>
> The database is on SCO 5.0.4 and ORACLE 7.3.4 I have create a index on
> every query part. The database is now 390 MB the database grows up to 8-9
> GB
> What can i do to make the query faster.
>
> Thanks Mike !
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 09 1998 - 03:49:46 CST