I’d like to do a query like this:

select meta().id from bucket where x=1 and y in [a,b,c]

Will a partial index on (x) where y = a or y = b or y = c

support complete pushdown to the indexes?

further, will this work:

index on (x, y asc) where y = a or y = b or y = c

support complete push down on:

select meta().id from bucket where x=1 and y in [a,b,c] order by y asc

offset 10 limit 100

thank you for your help