Indexes, Filters, and Other Animals

Scylla now supports a choice between Global and Local Secondary Indexes. Their performance characteristics will be widely different, and better or worse depending on the situation. Which will perform better, when and why? We will also discuss filtering of data, a technique to allow the server to select just parts of the data before sending it to client, yielding faster queries. What can be filtered, and in which situations will it yield a performance gain? How can we use indexes to speed up the performance of filtered queries? Those and other questions will be explored in this talk.