[dunwaldo]

I thought it was more for writes, but reading here looks like the index will also help reads

[v5c6]

Yes. Indexes are integrated into reads, with (near) standard SQL for managing them