Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sort without order by
After all, there's always the possibility that the query will go parallel and switch to a fast-full-scan from a full-scan.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Thomas Kyte wrote in message ...
>
>agreed. I would tend to add an order by to the query myself. Given that
they
>wanted to mimick the behaviour of a Sybase/sqlserver clustered index -- the
IOT
>would do it.
>
Received on Thu Nov 18 1999 - 13:14:17 CST