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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Oracle Query Taking Too Long

Re: Simple Oracle Query Taking Too Long

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 06 Sep 2006 22:18:17 +0200
Message-ID: <f5buf2p3mpaj75mlicp31kkcaeph0ibsol@4ax.com>


On Wed, 6 Sep 2006 12:54:04 -0700, "Bryan Hunter" <bryan_at_exitexchange.com> wrote:

>I agree with you on the index but this does not make sense to me why it does
>not come back in a matter of miliseconds, that is why I tried the index.
>This is a table not a view/join/sort/group by. The owner is the main owner
>of the DB 'STATS' and the type is 'TABLE'. Some additional information that
>I forgot about: The DB is 8.1.7 actually and when I first ran this query 1
>week ago it was miliseconds. What I have been performing was migrating this
>data into a larger table with full indexing on it. So I was selecting *
>from abc where rownum <= 1000 and inserting those into another table. Then
>deleting * from abc where rownum <= 1000. I noticed that it started running
>slowly and ran the select statement and it took over a minute. Now I am
>just trying to understand why row 1 does not come up instantly.
>
>

Post relevant information, not irrelevant.

'larger table' means ...
'full indexing' means...

We need *table and index definitions* and *explain plans*

Crystall balls have long been worn out by people like you.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 06 2006 - 15:18:17 CDT

Original text of this message

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