Re: newbie index question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Feb 2001 11:12:27 -0000
Message-ID: <982927631.10850.0.nnrp-10.9e984b29@news.demon.co.uk>

Compression does not affect the
number of row-entries, it merely eliminates as many duplicates of the leading columns as possible. Each row will individually
be represented by at least a rowid.

Clearly you haven't yet managed to
get hold of my book ;)

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

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Buck Turgidson wrote in message ...


>Hi Jonathan.  Could index compression reduce the amount of rows, or is that

 a logical, not physical construct?


>

>

Received on Fri Feb 23 2001 - 05:12:27 CST