Posted by Serge Rielau on 03/08/06 03:39

--CELKO-- wrote:
<snip>
Joe,

There is a difference between an ordered table and an object (table,
view, table-function, ..) with which you associate a "suggested order
for your viewing pleasure"
BTW, DB2 has shipped nested ORDER BY in V8 and we have not seen any issues.

What's wrong with allowing the definer of an object to propose such an
order and the user to say: "Hey whatever you say man, I want order, but
I trust you thought about how it looks best."

This is no more dangerous than asking for the special at your local
restaurant. No one forces you to eat it and you don't get it by default
either.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Back to original message]