Re: Rebuild Index

From: Dave Wotton <Dave.Wotton_at_it.camcnty.no-spam.gov.uk>
Date: 1998/03/31
Message-ID: <6fqdo6$q08@dns.camcnty.gov.uk>#1/1

masnani_at_corp2.pagemart.com wrote:
>Dave,
>I haven't really checked now, but am not sure if the alter index... rebuild
>command analyzes the index. As far as I remember , it does not. - Manish

Hi,

it definitely does ( at least, under Oracle 7.3.3.0.0 on Solaris 2.5.1 ):

SQL> select leaf_blocks from dba_indexes where index_name = 'POST_000';

LEAF_BLOCKS

                        <== ie. NULL, not analysed

SQL> alter index post_000 rebuild;

Index created.

SQL> select leaf_blocks from dba_indexes where index_name = 'POST_000';

LEAF_BLOCKS

25 <== analysed

Dave.

-- 

To reply by email, remove the "no-spam" bit from my email address.

Received on Tue Mar 31 1998 - 00:00:00 CST