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 06:38:17 GMT
Message-ID: <3859DA81.94F9DC17@cc.gatech.edu>


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.

Received on Fri Dec 17 1999 - 00:38:17 CST

Original text of this message

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