MY DATABASE IS SO SLOW

From: Michael Wagner <wagner_at_eurolab.at>
Date: 7 Dec 1998 15:52:29 GMT
Message-ID: <01be21f8$d6c519c0$1401a8c0@test>

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 ! Received on Mon Dec 07 1998 - 09:52:29 CST