New interactive course: Secondary indexes in Manticore
It should answer all your questions about how it works
