Re: ORDER BY question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 8 Dec 2006 06:22:21 +0100
Message-ID: <4578f68d$0$13462$426a74cc@news.free.fr>

<baoqinye_at_gmail.com> a écrit dans le message de news: 1165549775.331061.53010_at_16g2000cwy.googlegroups.com...
| The architecture group of our company has told us to avoid using ORDER
| BY in our queries. Their reasons are:
|
| - In 10G, order by is incredibly inconsistent. They had an example with
| only 2 rows of data that was extremely slow. Even if it looks like it
| works alright, it's not guaranteed to, and we can't predict when
| it'll fail. That instability is one of the main reasons against it.
|
| - ORDER BY a primary key, especially when the primary key is not used
| in the where clause, has the worst performance and is definitely to be
| avoided.
|
| Is this true?
|

No.
Ask them to prove what they said and in first place, post their 2 rows example.

Regards
Michel Cadot Received on Thu Dec 07 2006 - 23:22:21 CST