RE: Too many rows reported for index in tkprof
- From: "Charu Joshi" <joshic@xxxxxxxxxxxxxx>
- To: "Oracle List" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Aug 2005 06:08:46 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Wolfgang Breitling
Sent: 10 August 2005 19:11
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
Cc: ldutra@xxxxxxxxxxxxx; Deepak Sharma; oracle-l@xxxxxxxxxxxxx
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
--
//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
*********************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
