SAP Note 1049390 - Poor performance for multiple OR conditions and IN lists

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/1049390 (SAP Service marketplace login required)

Key words :
index rowid coss           index range scan coss~0in oracle 9, index rowid coss                    index range scan coss~1             table access, index rowid coss                 index range scan coss~0             table access, index rowid coss                 index range scan coss~0, concatenation             inlist iterator                table access, optimizer merge fix reason, current optimizer merge fix, shows significantly lower costs, table access, sapnet note 981875 oracle 9

Related Notes :

992261Optimizer merge fix for Oracle 9.2.0.8
981875Optimizer merge fix for Oracle 10.2.0.2