QLDB doing a full table scan when using an OR across two indexed fields

We have a table T with two indexed fields A and B. When we query the table using the following query, QLDB does a full table scan (by evidence of the IO stats and latency):

select * from T where A = 'x' or B = 'y'

Why? And is that expected?

主题

区块链

标签

Amazon Quantum Ledger Database

语言

English

Andrew

已提问 8 个月前214 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

Well, a team member just pointed out that it is not supported according to this https://qldbguide.com/guide/data-design/#transaction-timeout

 --Multiple indexed fields (VIN, LicensePlateNumber) lookup using the OR operator
 --Disjunctions not currently supported 
 SELECT * FROM VehicleRegistration
 WHERE VIN = '1N4AL11D75C109151' OR LicensePlateNumber = 'LEWISR261LL'

This seems like a bizarre omission.

Andrew

已回答 8 个月前

QLDB doing a full table scan when using an OR across two indexed fields

相关内容