Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE ORDERED TABLE

Re: CREATE ORDERED TABLE

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: Fri, 17 Dec 1999 19:19:58 GMT
Message-ID: <385A8D02.C38F2AD8@cc.gatech.edu>


I don't know why you would use an index organized table when you are just going to read the entire table. If you were using this table to join so that your selects would decode a state code into a state name, then I can see the use for an index organized table.

Ed Stevens wrote:

> In article <3859DA81.94F9DC17_at_cc.gatech.edu>,
> Paul Bennett <bennett_at_cc.gatech.edu> wrote:
> > Troy Tinnes wrote:
> >
> > > Why would you want to do this? The first row you insert into this
> table
> > > later will put it out of order anyway. If you're thinking that it
> will
> > > speed access time - you might be right if you need to do a full
> table scan
> > > on the one column .... but then again, why not create an index?
> > >
> >
> > If you have a code table with the states in it, why sort it each time
> a client
> > retrieves it for a drop down. Why not sort it once? You have to
> read the
> > entire table anyway, so why waste space in an index.
> >
> > -- Paul
> >
> >

>

> --
> A perfect application for an Index-Oraganized table.
>

> Ed Stevens
> (Opinions are not necessarily those of my employer)
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 17 1999 - 13:19:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US