Performance Optimization with Dynamic Parameters

Blitz Report strongly recommends using dynamic SQL anchors like the `n=n` anchor instead of the `nvl(:bind_variable, column_name)` structure. Blitz Report creates dynamic SQL at run-time, combining the extraction SQL and user parameters optimally.

The `n=n` (e.g., `1=1`) anchor allows unused parameters to be dynamically dropped at run-time. If a user does not enter a value for a parameter, the associated WHERE clause is omitted entirely from the generated SQL, preventing unnecessary parsing and maintaining efficient execution plans.

If the user provides a value, Blitz Report inserts the parameter’s WHERE clause immediately before the `1=1` anchor, making it part of the complete WHERE clause. If no value is provided, the anchor remains intact (`WHERE 1=1 AND…`), ensuring the query executes efficiently without filtering.