Re: how to faster 100K records?

Use snapshots for your daily reports, they execute once, everybody can select from them at any time with milli-secs of execution.

Try to also do an explain plan of your query, your index might not be used.

On Mon, 22 Oct 2001 17:06:02 +0900, "sang" <sang_at_technical-e.co.jp> wrote:

>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
>
>

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email