RE: Does start with/connect by uses full table scan?

You want to make sure there is an index on the start with and connect by clauses. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707)

RE: Does start with/connect by uses full table scan?

Thanks a lot Guy. Very good link with lot of examples. Rao -Original Message- Sent: Tuesday, September 25, 2001 6:30 AM To: Multiple recipients of list ORACLE-L According to this page, you would use concatenated indexes: http://www.arsdigita.com/books/sql/trees.html Hmmm. g ---

RE: Does start with/connect by uses full table scan?

According to this page, you would use concatenated indexes: http://www.arsdigita.com/books/sql/trees.html Hmmm. g -Original Message- Sent: Monday, September 24, 2001 7:36 PM To: Multiple recipients of list ORACLE-L List, Does Oracle go for full table scan or does it use indexes wh

Does start with/connect by uses full table scan?

List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)