Correct, I did not read the post carefully, thought he was saying Full scan
does not return rows in order, so was stating the fact that rows come sorted
using Index Full Scan.
My fault!
Waleed
-Original Message-
Sent: Saturday, October 25, 2003 5:34 AM
To: Multiple recipients of list ORA
Hi!
You can't have ascending nor descending indesc fast full scans. This
(asc/desc) only works with range or regular full scans.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, October 25, 2003 4:59 AM
> But the fact is, the a
But the fact is, the access path is still a valid path if the user needs the
data returned ordered on the indexed columns.
Index_asc or Index_desc should do the job without extra cost.
Waleed
-Original Message-
Sent: Friday, October 24, 2003 9:39 PM
To: Multiple recipients of list ORACLE-
