Re: Too many rows reported for index in tkprof

Because it is repeatedly scanned inside a nested loop.

Leandro Guimaraes Faria C. Dutra wrote:
> Hi all.
>
>
>
> Oops! Problem is, ps0boleto_brl is an index with less than 100k
> rows.
>
> So what's wrong here? How can such a small index give such a high
> row number in tkprof?
>
> Ah, this is PeopleSoft 10 on Oracle 8.1.7.
>
> Thanks in advance!
>
>

-- 
Regards

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