3rd Column Blues
Rules Based Oracle Bug

...where mandt = :A1
      and kokrs = :A2
      and belnr in (:A3, :A4).

COEP____0

mandt
kokrs

---

belnr
buzei

BELNR is the 3rd column in this index. Using any operator other than equals on this 3rd column can result in a database scan instead of an index search. It is a bug in rules based Oracle.

Remedies for the 3rd Column Blues

• Specify "=" criteria on the 4th column
• Use a different index

Unique index COSS___0

MANDT
LEDNR
OBJNR
GJAHR
WRTTP
VERSN
KSTAR
HRKFT
VRGNG
PAROB
USPOB
BEKNZ
TWAER
PERBL

Specify "=" criteria on the 4th column

...where mandt = :A1
      and lednr = :A2
      and objnr in (:A3, :A4)
      and gjahr = :A5.

Use a different index (Index COSS___1)

...where objnr in (:A1, :A2)
      and mandt = :A3
      and lednr = :A4
      and versn = :A5.