Re: Trying to understand the BITMAP AND operation a bit better
From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Wed, 6 Jan 2016 15:14:15 -0600
Message-ID: <CAPZQniV3o=_XEjJ2y6axAM7JCmYkM2vi2YLsNh8RrxfTj_5V6A_at_mail.gmail.com>
Sayan,
Date: Wed, 6 Jan 2016 15:14:15 -0600
Message-ID: <CAPZQniV3o=_XEjJ2y6axAM7JCmYkM2vi2YLsNh8RrxfTj_5V6A_at_mail.gmail.com>
Sayan,
That is an excellent observation - I knew I had been staring at this for way too long! :) And now I feel kinda stupid.... oh well. :)
Thanks much.
On Wed, Jan 6, 2016 at 3:08 PM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:
> Hi Charles,
>
> Note that 7-11 lines have 5 "Starts" in the first plan, because previous
> steps(NL to FTS of DIMENSION2) returned 5 rows, but there is only 1
> "Start" in second plan for these operations.
> So each of BITMAP INDEX SINGLE VALUE in first plan executed 5 times
> instead of 1 in the second plan.
>
>
> --
> Best regards,
> Sayan Malakshinov
> http://orasql.org
>
-- Charles Schultz -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 06 2016 - 22:14:15 CET