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

References:

Too many rows reported for index in tkprof
From: Leandro Guimaraes Faria C. Dutra

Other related posts: