Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE ORDERED TABLE
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
> >
> >
>
>
>