Re: index...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 20 Jul 2001 18:50:41 +0100
Message-ID: <3B586F71.1779@yahoo.com>

Jean wrote:
>
> Bonjour ,
> Quelle est la meilleur formule pour calculer la taille d'un index à
> retailler ?
> merci
> Pierre.jean2_at_worldonline.fr

I hope your English is better then my French - but if you are asking how large an index is, you can:

ANALYZE INDEX and then look at LEAF_BLOCKS. This is a good estimate

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Fri Jul 20 2001 - 12:50:41 CDT