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?

-- 
Regards

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