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?

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

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