Re: CREATE ORDERED TABLE

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