Re: index storage

From: Thomas Pall <tpall_at_bga.com>
Date: 15 Nov 98 00:21:48 GMT
Message-ID: <364e1e9c.0@feed1.realtime.net>

To add to the list. Oracle has reverse indexes (the bytes are reversed so that a gradually changing column can be indexed as a rapidly changing value -- to avoid contention and hot spots when traversing an index) and index only tables, in which the data is stored with index. This may be redundant, but also clusters: tables which share data columns are placed so the shared data is not duplicated.

Paul Chang (pch_at_pinnacle.ebay.sun.com) wrote:

: Hi,

: Sybase has clustered and non-clustered index.
: How about Oracle? How Oracle store index? any difference from sybase?

: thanks,

: Paul.

-- Received on Sat Nov 14 1998 - 18:21:48 CST