Re: CREATE ORDERED TABLE

From: Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com>
Date: Fri, 17 Dec 1999 13:22:03 GMT
Message-ID: <83dddo$ma8$1@nnrp1.deja.com>

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 - 07:22:03 CST