RE: RE: Index-Organized Table experiences

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 28 Apr 2004 12:41:08 -0700
Message-Id: <1083181268.17431.1473.camel@poirot>

On Wed, 2004-04-28 at 11:48, Michael Fontana wrote:
> FWIW -
>
> Index-only tables (their IBM name) were in DB2 first, and have been
> around for many, many years.
>

I recall officially requesting this in 1994/95. No doubt I was not the first nor the last to ask for it.

As soon as you build a lookup/intersection table with 2/3 columns and learn that all data retrieval is from the index, the natural question is "Why don't you just let me build the index, without the table?"

It would be interesting to know how many other requests they received for this.

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 28 2004 - 14:38:40 CDT