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: Optimizer problem?

Re: Optimizer problem?

From: Marcel Claus <Marcel.Claus_at_Informatik.Uni-Oldenburg.DE>
Date: 1997/10/08
Message-ID: <61fcnu$ce5@news.Informatik.Uni-Oldenburg.DE>#1/1

Phil Tsao wrote:

> Hi,
>
> I was wondering if any one has experienced the same problem.
> I have a loop to add 10,000 rows to a table one by one then another loop
>
> to delete each row one by one. After doing so a few times, the
> "select count(*) from table" starts doing table scan ( and physical
> read)
> every time. I thought the index (on primary key) was corrupted due to
> the massive insert & delete and rebuilt it. It did not help.
> The only way I can force using index is to use hint or the following:
>
> select count(*) from table where pkey > -9999;
>
> Is there anything you know that causes this to happen?
> Thanks in advance.
>
> --
> Phil Tsao
> philt_at_technologist.com

Did you check the amount of free RAM for ORACLE? Maybe this is insufficient, so ORACLE has to use the disks. Received on Wed Oct 08 1997 - 00:00:00 CDT

Original text of this message

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