Select shortest index for known and unknown sizes

Description

When running a query that involves equality matching (fixed size index) and ordered matching (unknown size) prefer the shortest index to speed up query time.

Bug - based on the alphabetical ordering, the shortest index might not be chosen, causing a performance hit.

e.g. "content = '5' AND category <= 1000" content should be chosen, but because alphabetically 'co' is before 'ca' then category is searched first, and
since it is of unlimited size, the shortest scan is skipped.

Workaround

None

Acceptance Test

ExplainPlanShortestIndexTest

Assignee

Meron Avigdor

Reporter

Meron Avigdor

Labels

None

Priority

Medium

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

None

Edition

Open Source

Platform

All
Configure