Skip to main content
Firebolt supports the use of query hints, which are special comments embedded in your SQL statements. These hints allow you to influence the behavior of the query planner, giving you greater control over how your queries are executed. Query hints are comments that start with /*! and end with */. The following example demonstrates the syntax using the hint no_partial_agg:
SQL source
explain(physical)
select /*! no_partial_agg */
  AVG(quantity),
  location_id
from
  fact_sales
group by
  location_id;

​
Supported hints in Firebolt