Using an index for lookups of multiple records


#1

When I set up an index on source.sig, the query

select * from default where source.sig = "ytHl-__aF1oA";

uses the index and runs in milliseconds. However

select * from default where source.sig = "ytHl-__aF1oA" or source.sig = "pk_wg_05NHUA";

and

select * from default where source.sig in ["ytHl-__aF1oA"];

do not use the index and take fifteen minutes to run. Is there any way to use the index to speed lookups of multiple records? If not, is this something that will be in the beta release?


#2

Hi,

You are correct about the current behavior in DP3. Indexes are used for =, <, <=, etc.

OR and IN do not yet use indexes optimally. We have JIRA tickets to track this issue and will address it for Beta and GA (or sooner).

Thanks.