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 DBA