RE: Too many rows reported for index in tkprof

Just be aware of the side-effect that the compute statistics clause will wipe out any histogram on the column(s) on which index is being created/rebuilt (atleast as of 9i).

Regards,
Charu

PS: I have sent this post once under a wrong title and once only to Wolfgang . Apologies for that. Haven't got used to doing reply-all yet.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfgang Breitling Sent: 10 August 2005 19:11
To: Thomas.Mercadante_at_labor.state.ny.us
Cc: ldutra_at_toyota.com.br; Deepak Sharma; oracle-l_at_freelists.org Subject: Re: Too many rows reported for index in tkprof

Actually don't use either - use create/rebuild index ... compute statistics;

You get the statistics "for free" as part of the index creation or rebuild. In oracle 10 that's even the default.

Mercadante, Thomas F (LABOR) wrote:
> Probably should have used "analyze" :O
>
>
>>A trivial, but important question is whether you
>>analyzed the index after creating it?
>
>
> Sure, with DBMS_STATS.
>

--
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l


*********************************************************
Disclaimer:

The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if any) are privileged and confidential material of MBT and should not be disclosed to, used by or copied in any manner by anyone other than the intended addressee(s).   In case you are not the desired addressee, you should delete this message and/or re-direct it to the sender.  The views expressed in this E-mail message (including the enclosure(s) or attachment(s) if any) are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of MBT.

This e-mail message including attachment/(s), if any, is believed to be free of any virus.  However, it is the responsibility of the recipient to ensure that it is virus free and MBT is not responsible for any loss or damage arising in any way from its use

*********************************************************
--
http://www.freelists.org/webpage/oracle-l