Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Efficiency of hierarchical queries
The only place I've used a hierarchical query was on a table of about 250,000 records, and it returned my results instantly. So I assumed that it was using my indexes. If it was doing a full table scan on this table, I would have expected it to be *much* slower, because without the indexes any query on the table is extremely slow.
On Mon, 02 Feb 1998 13:06:53 -0500, Keith D Gregory <keith_at_inconcert.com> wrote:
>Looking at the execution plan for a hierarchical query, I see a table
>scan, no matter what I do for indexing hints. It seems to me that this
>will result in very poor performance for the table in question, which
>could contain several million rows.
>
>So, is there something magical about the CONNECT BY operation, or will
>it really scan my table?
>
>-kdg
Received on Mon Feb 02 1998 - 00:00:00 CST