Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Oracle Query Taking Too Long
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 DBAReceived on Wed Sep 06 2006 - 14:17:24 CDT
![]() |
![]() |