Re: CREATE ORDERED TABLE

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 17 Dec 1999 06:56:18 -0000
Message-ID: <945414066.9556.1.nnrp-03.9e984b29@news.demon.co.uk>

Also if you have a data warehouse with partitioned data that becomes read-only after a while it could be perfectly reasonable to rebuild it packed and sorted along the most commonly accessed dimension.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Paul Bennett wrote in message <3859DA81.94F9DC17_at_cc.gatech.edu>...
>Troy Tinnes wrote:
>
>> Why would you want to do this? The first row you insert into this table
>
>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
>
Received on Fri Dec 17 1999 - 00:56:18 CST