Wrong results during estimation of OR-expansion (Doc ID 392055.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Wrong results can occur when all the following is true,
1. A plan using BITMAP OR operation,
2. Missing predicate in the plan
3. Disabling of or-expansion


Execution Plan is something like:
--------------------------------------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes |TempSpc|Cost (%CPU)| Time |

--------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 13765 | 564K| | 1146 (17)| 00:00:14 |
| 1 | SORT ORDER BY | | 13765 | 564K| 1752K| 1146 (17)| 00:00:14 |
| 2 | TABLE ACCESS BY INDEX ROWID | TABLE_NAME | 13765 | 564K| | 992 (20)| 00:00:12 |
| 3 | BITMAP CONVERSION TO ROWIDS | | | | | | |
| 4 | BITMAP OR | | | | | | |
| 5 | BITMAP CONVERSION FROM ROWIDS| | | | | | |
| 6 | SORT ORDER BY | | | | | | |
|* 7 | INDEX RANGE SCAN | INDEX_NAME | | | | 5 (0)| 00:00:01 |
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms