SingleStore introduces projections, a new feature that allows users to create secondary tables with different sort and shard keys than the primary table. Projections can be used to speed up range filters, GROUP BY queries, collocated joins, and COUNT(DISTINCT ...) operations by allowing data to be processed locally on partitions without requiring expensive cross-node data movement. Projections are a generalization of traditional secondary indexes and materialized views, but they offer more flexibility and power. They can be used sparingly, only when there is no alternative base table organization that will meet the user's needs. The future of projections includes improvements to the query optimizer and additional features such as online CREATE PROJECTION and bookmark lookups.