Oracle is to slow, why?

We're making this simple database application in which we have to import around 230,000 registers into one table that has 8 foreign keys and a child table with more than 2 million registers. We began using visual foxpro through Odbc and it was a real large process, then we make some stored procedures running directly on the server and it was worst, finally we used SqlLoader and it was a little better (half an hour), then we have the information ready and we try to make a simple query to  the 2 million registers table and it is "super slow". We are making the query on one of the indexed fields. We have Orale 8.05 installed on a PIII-550 with 128 MB and a 9GB SCSI HD.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 07 2000 - 00:00:00 CDT