Efficiency of hierarchical queries

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