Re: Suggestions for first exam ...

> There is something in that article that got a
> chuckle from the guys at the office:
>
> > Three tuning goals for sort operations are the following:
> > .- Avoid sorts whenever possible.
>
> I mean, "avoid sorts" is a tuning goal for sort operations?
> Exactly how do we then return results in the right order?
> It may be a design goal, but it is NOT a "tuning goal for sorts"...

From the Oracle education materials, if I remember them correctly, the advice on avoiding sorts whenever possible was not meant that you should not do a sort if you need to return data in a specific order. That is impossible. Rather, it was meant to make you think on whether you needed the sort at all. For instance, do you really need to use UNION (which needs a sort) when UNION ALL will do (which doesn't need a sort). That sort of thing was what the materials were referring to.  

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"