Re: index rebuild vs compress

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 21 Dec 2003 12:03:46 -0800
Message-ID: <cf90fb89.0312211203.5b4bc3dd@posting.google.com>

"zeb" <thierry.constant1.nospam_at_free.fr> wrote in message news:<3fe55dbc$0$24019$626a54ce_at_news.free.fr>...
> Hi,
>
> What is the difference between index rebuild and compress ?
> which is better ?

Rebuild does only re-balance inodes while compress makes index less I/O intense, influencing the CBO:

http://www.jlcomp.demon.co.uk/faq/compress_ind.html

http://www.jlcomp.demon.co.uk/ch_07.html Received on Sun Dec 21 2003 - 14:03:46 CST