Kirill Tkalenko created IGNITE-28331:
----------------------------------------
Summary: Fix SQL search by _key for a composite pk in Calcite
engine
Key: IGNITE-28331
URL: https://issues.apache.org/jira/browse/IGNITE-28331
Project: Ignite
Issue Type: Improvement
Affects Versions: 2.17
Reporter: Kirill Tkalenko
Assignee: Kirill Tkalenko
I discovered that for a simple pk (consisting of one column), queries like
"select name from person where id = ?" use the pk index with a single-value
lookup.
However, if the pk is composite, a full scan of the primary key index will be
used. This is neither obvious nor efficient; this needs to be fixed for the
Calcite engine.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
