Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performace on VERY simple database...
It would usually physically put the rows in that order. You still need the
order by to get the rows out in that order - don't rely on the actual
physical order of the rows, you'll get burned. It might help if you
frequently access the rows in that particular order, but only for a little
while. As soon as you start doing deletes, inserts, updates (to that
column) all bets are off and things begin to degrade.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Frank" <fbortel_at_home.nl> wrote in message news:3E15731E.5060200_at_home.nl...Received on Fri Jan 03 2003 - 10:22:37 CST
> Bert Bear wrote:
> > 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
> >>
> >
> >
> >
>
> Hmmm understand you don't follow, as I was too lazy to
> answer twice - the sort bit was intended for the op, the
> he did bit for you.
>
> Your performance benefits would probably be on large tables;
> kinda' reorg of the table, tho I cannot explain that for the
> latest versions (extents not being a performance issue, and
> all that). Indexes would be reorganized as well, and that could
> be benificial (non even distributed values in the tree).
>
> Anyone with in depth knowledge care to explain this performance
> gain when rebuilding a table with a select * from org_table order
> by x?
>
> Frank
>