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 21:17:24 +0200
Message-ID: <qk7uf2pjlm2nm6p072a74r17domgeukasj@4ax.com>


On Wed, 6 Sep 2006 11:31:36 -0700, "Bryan Hunter" <bryan_at_exitexchange.com> wrote:

>I have oracle 8.16 running on a sun enterprise 450 lots of ram and
>processor.
>I have a table abc with no index on it and 40 million rows in it.
>I am running the query "select * from abc where rownum = 1" and that takes
>42 seconds to run. The table was analyzed this morning. I then applied and
>index on the leading column and re ran the same query, still take 42
>seconds. I then ran the same query but on table xyz with 80 million rows,
>two indexes and a primary key, it took .03 seconds to run. I looked at the
>explain plan on both and they are both table access full with a count
>stopkey on it. I am confused as to why this would be so slow. Any ideas?
>
>Bryan
>
>
>

Apples != Pears.

Desupported version, buggy like hell.
Who can tell?

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

Original text of this message

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