Re: Too many rows reported for index in tkprof

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: ldutra@xxxxxxxxxxxxx
  • Date: Tue, 09 Aug 2005 14:42:04 -0600

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2005