Explanation on Primary Scan / Secondary Scan

Hi, this optimization will be added. for now, the workaround is to create a secondary index as you observed. But yes, you are right that a range scan should be performed on the primary index. Thanks.