Explain plan shows unusable index as selected for matching

Description

Query with the following WHERE clause: "nestedField.id < 20 OR nestedField.id > 80" was invoked on a indexed field that was declared as SpaceIndexType.EQUAL and not SpaceIndexType.EQUAL_AND_ORDERED

Although the index was ignored during matching, the explain plan description considered it as selected.

Fixed

Assignee

Meron Avigdor

Reporter

Meron Avigdor

Labels

None

Priority

Minor

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

XAP

Edition

Open Source

Platform

All