Re: how to faster 100K records?

This is going to be difficult to respond to, since there is no information on Oracle version, operating system, database configuration, etc. My first guess is that your tables and indexes are on the same physical drive, a cardinal sin. Physically separating the indexes from the tables (that is, putting the index tablespace on one disk and the tables on another) will dramatically improve your query speed.

Feel free to email me privately and we can discuss this further.

"sang" <sang_at_technical-e.co.jp> wrote in message news:<9r0iut$je1$1_at_nn-os106.ocn.ad.jp>...
> Hi, alls
>
> In my DB, one table has 100K records.
> I use one application to insert data to this table only,
> and in another application i get the data and make
> the day report of row data.
>
> But it is slowly, the SELECT spends me 7 or 8 seconds,
> i used INDEX with PRIMARY KEY also.
>
> How can i make faster ?
>
> Thanks in advance.
>
> webjb
Received on Mon Oct 22 2001 - 10:39:27 CDT