Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to faster 100K records?

Re: how to faster 100K records?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 22 Oct 2001 17:25:03 GMT
Message-ID: <3bd4562e.3636090802@news.globix.com>


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
Received on Mon Oct 22 2001 - 12:25:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US