Re: Bitmap index partitions and recursive calls

From: Jonathan Lewis <>
Date: Fri, 28 May 2010 22:28:17 +0100
Message-ID: <>

"Pratap" <> wrote in message
> Hi,
> Oracle
> 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.

Have you tried enabling SQL trace and seeing if those recursive calls appear as SQL in the trace file ?


Jonathan Lewis
Received on Fri May 28 2010 - 16:28:17 CDT

Original text of this message