Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suggestions for first exam ...
Oracle's implemention of the UNION does not involve a hash table. The data from the two sources involved in the UNION are sorted so that duplicates are removed.
HTH,
Brian
ctcgag_at_hotmail.com wrote:
>
> Brian Peasland <dba_at_remove_spam.peasland.com> wrote:
> >
> > 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.
>
> Apropos of little, a UNION can theoretically be performed without
> sorting by using a hash table. Does Oracle entertain this possibility?
>
> I imagine it would brutalize many poor saps who don't specify "order by"
> but assume it will be sorted anyway.
>
> Xho
>
> --
> -------------------- http://NewsReader.Com/ --------------------
> Usenet Newsgroup Service New Rate! $9.95/Month 50GB
-- =================================================================== 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"Received on Mon Sep 29 2003 - 12:15:01 CDT