The upcoming ScyllaDB Open Source 3.1 release introduces support for local secondary indexes alongside the existing global indexing, providing users with more flexible query options tailored to their specific needs. While global indexes are beneficial for scaling across nodes with more complex writes, local indexes optimize queries that are partition-local, reducing latency by ensuring that the data retrieval occurs on the same node. The blog post discusses use cases for both indexing types, demonstrating that local indexes can significantly enhance performance for queries that are restricted to a single partition. The article also highlights the implementation details and performance implications, revealing that local indexes can outperform global ones in specific scenarios due to reduced inter-node communication. ScyllaDB's indexing strategy leverages materialized views, allowing for further optimization and flexibility in query execution, with future enhancements anticipated to enable more sophisticated indexing options.