We have a 50 gig database in Oracle 7.1 (currently testing 7.3). Raw data consists of about 15 gig. We have the data denormalized to avoid joins. The amount of time it takes to get results from queries we feel is unacceptable (3 hours for an average query, 8 hours for anything complex). The database consists of 3 main tables (customers - 13 million records, orders - 27 million records, items - 80 million records). We are wondering if going to a star schema would improve performance? Any recommendations would be appreciated. Received on Thu Oct 17 1996 - 00:00:00 CEST
Original text of this message