fdb-record-layer icon indicating copy to clipboard operation
fdb-record-layer copied to clipboard

old planner plans projected columns without covering index

Open normen662 opened this issue 3 years ago • 0 comments

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.

normen662 avatar Jun 29 '21 19:06 normen662