Re: Trying to understand the BITMAP AND operation a bit better
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 7 Jan 2016 00:08:20 +0300
Message-ID: <CAOVevU4ipQjYOxJZN=TSO4xj3+kkydQT7vwTxQ2rOB=2rQod1g_at_mail.gmail.com>
Hi Charles,
Date: Thu, 7 Jan 2016 00:08:20 +0300
Message-ID: <CAOVevU4ipQjYOxJZN=TSO4xj3+kkydQT7vwTxQ2rOB=2rQod1g_at_mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 06 2016 - 22:08:20 CET