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?
Received on Thu Dec 07 2006 - 21:49:35 CST