Re: CREATE ORDERED TABLE

From: <sacq_at_usa.net>
Date: Fri, 17 Dec 1999 19:15:55 GMT
Message-ID: <83e258$669$1@nnrp1.deja.com>

In article <3859B671.C53A413D_at_cig.nml.mot.com>, Troy Tinnes <q10641_at_cig.nml.mot.com> 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?

Certainly you should create an index on the column. However, I can easily see how it might be quite worthwhile to pre-sort the data; by doing so, you ensure that (initially) the index is perfectly clustered with respect to the table. This will speed all index range scans immeasurably.

Mind, you will probably be able to get better improvements by doing other things -- using partitioned tables, for example -- but in some cases that might not be a good option.

Regards,

-bn

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