Using an index for lookups of multiple records

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?

1 Answer

« Back to question.

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.