Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performace on VERY simple database...
Frank,
I'm not following. I totally agree with you, the only way to insure an order (e.g. sort) is by using the "ORDER BY" clause. I do find there is sometimes (and I mean sometimes) a performance advantage, when reloading / recreating a table and using a subquery (in the insert or create) with an ORDER BY clause.
Bert
"Frank" <fbortel_at_home.nl> wrote in message news:3E149C76.1010507_at_home.nl...
> Bert Bear wrote:
> > Stephan,
> >
> > Ah, didn't you post this question as part of a thread in
> > comp.database.oracle.server?
> >
> He did...
>
> And you don't sort! The fact that your records are sorted the same
> way is pure chance!!!
>
> Sort is done by using the ORDER BY clause.
>
> Frank
>
Received on Thu Jan 02 2003 - 18:05:25 CST