Re: Bitmap index partitions and recursive calls

From: joel garry <joel-garry_at_home.com>
Date: Fri, 28 May 2010 14:53:11 -0700 (PDT)
Message-ID: <b26e6ae9-2185-40cf-9372-eaf9090685c2_at_z15g2000prh.googlegroups.com>



On May 28, 4:13 am, Pratap <pratap.deshm..._at_gmail.com> wrote:
> Hi,
>
> Oracle 10.2.0.4
>
> What is the relation between partitioned bitmap indexes and number of
> recursive calls shown by Autotrace? I have seen that as the number of
> partitions on a table increase, for a query using bitmap indexes, the
> number of recursive calls also increase. When the number of partitions
> on the table are reduced, the same query shows lower recursive calls.
>
> I have discounted query parsing by running the queries 3 times before
> observing the recursive calls.
>
> Regards,
> Pratap

I don't know much about it, but after looking at http://www.jlcomp.demon.co.uk/06_bitmap_2.doc I guess it is recursively loading temporary tables. You don't have to guess, see how to tell in the doc.

jg

--
_at_home.com is bogus.
http://arstechnica.com/science/news/2010/05/when-science-clashes-with-belief-make-science-impotent.ars
Received on Fri May 28 2010 - 16:53:11 CDT

Original text of this message