Re: Analyze index after creation

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/05/02
Message-ID: <390ED303.7080@yahoo.com>#1/1

Sybrand Bakker wrote:
>
> Indexes are not analyzed automatically after creation, so yes, you should
> analyze.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> MGC <gconron_at_zdnetmail.com> schreef in berichtnieuws
> 8ekl38$p7e$1_at_nnrp1.deja.com...
> > Quick question - after creating indexes on a large table (50 million+
> > records), should you do an analyze on the table and all indexes or is
> > this an unnecessary step (assuming that the indexes are valid and
> > useful)?
> >
> > Thanks,
> > Greg Conron
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

(I think) 8i (or 8i.2) now has a feature to analyze as you build...

Cheers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Tue May 02 2000 - 00:00:00 CDT