[thelist] mysql - null - returns results anyway
Phil Turmel
pturmel-webdev at turmel.org
Wed Dec 23 09:33:48 CST 2009
On 12/22/2009 10:53 PM, r937 wrote:
>> ... I often find myself using these sorts of quick-and-dirty queries
>> as the basis for views, in which case the extra
>> "order by" is useful and appropriate.
>
> ORDER BY is ~never~ appropriate for a view
>
> full stop
>
>
> ;o)
>
Hmmm. Learn something new every day. I'm now going to have to play
with query analyzers on the platforms I have at hand to see if the
optimization I thought mattered was a figment of my imagination.
Thanks for the tip. Can you tell I'm an EE, not a CS grad?
Phil
More information about the thelist
mailing list