Serving optimizations
RisingWave provides a variety of optimizations to improve the performance of serving queries.
This section outlines best practices for serving optimizations.
SQL Optimizations
Leverage predicate pushdown
Predicate pushdown allows filtering operations (predicates) to be applied as early as possible in the query pipeline. This means that instead of retrieving all data and then filtering it, RisingWave filters the data at the storage level.
Examples:
Use indexes to accelerate your queries
Indexes in RisingWave are used to accelerate batch queries. They are incrementally maintained, similar to materialized views but with minimal computation. Therefore, they are cost-effective to create. We encourage users to detect the patterns in batch queries and create indexes if the pattern occurs frequently or/and a batch query is slow.
You can check the Indexes page for more details on how to create and use indexes.