Oracle LIKEC query doesn't use index
|Reported by:||Jani Tiainen||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||master|
|Cc:||Matt Boersma||Triage Stage:||Accepted|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
It seems (not confirmed from Oracle officially) LIKEC query doesn't use index at all, you get always full table scan that is costly when number of rows starts to grow.
Like queries uses index as expected with same parameters.
Change was done when fixing #5985
Change History (18)
comment:1 Changed 7 years ago by
|Patch needs improvement:||unset|
|Triage Stage:||Unreviewed → Accepted|