Inefficient scan in query with OR and AND combination

Description

In the following query
SQLQuery<MyPojo> query = new SQLQuery<MyPojo>(MyPojo.class, "(category > 50000 OR category < 10) AND content = '6'")

category - EXTENDED index
content - BASIC index

Some of the objects are scanned twice.

Workaround

None

Acceptance Test

explain plan test

Assignee

Yechiel Feffer

Reporter

KobiK

Labels

Priority

Medium

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

None

Edition

None

Platform

All
Configure