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

已提問 3 年前檢視次數 530 次

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

已回答 3 年前

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

新增您的答案

相關內容