fdb-record-layer
fdb-record-layer copied to clipboard
old planner plans projected columns without covering index
RecordQuery query = RecordQuery.newBuilder()
.setRecordType("MySimpleRecord")
.setRequiredResults(Collections.singletonList(field("num_value_3_indexed")))
.build();
The old planner plans this query as an unbounded index scan over some index (MySimpleRecord$str_value_indexed
) that does not provide num_value_3_indexed
. That can be improved by utilizing a covering scan over MySimpleRecord$num_value_3_indexed
which does provide that column num_value_3_indexed
.