Re: Bitmap index partitions and recursive calls
From: Pratap <pratap.deshmukh_at_gmail.com>
Date: Tue, 1 Jun 2010 04:55:52 -0700 (PDT)
Message-ID: <d65eefdc-31e5-4ae2-bc27-5ed2e662c877_at_m21g2000vbr.googlegroups.com>
Hi,
Date: Tue, 1 Jun 2010 04:55:52 -0700 (PDT)
Message-ID: <d65eefdc-31e5-4ae2-bc27-5ed2e662c877_at_m21g2000vbr.googlegroups.com>
Hi,
I had a look at the trace file and there are calls to TBL$OR$IDX$PART $NUM with different parameters. It seems the recursive calls are due to sub-query pruning.
Regards,
Pratap
Received on Tue Jun 01 2010 - 06:55:52 CDT