Re: Oracle is to slow, why?

Hi.

 You don't say if you are using leading field of index.  If you don't - optimizer can not use that index.  Make an EXPLAIN PLAN to verify what access path is used by optimizer.

 HTH. Michael.

In article <8clotp$obo$1_at_nnrp1.deja.com>,   rbasurto_at_my-deja.com wrote:
> 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.
>

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