Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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