'BigQuery Stored Procedure VS BigQuery Scripts
I am able to perform a task of join and aggregation using both Big Query Script and BigQuery Stored Procedure, which is better , which one should be my first choice to execute the task as a BigQuery Script or as a BigQuery Stored Procedure. Is there any advantage or disadvantage of use one over the other.
Solution 1:[1]
I don't know for BQ but in a lot of databases, Stored procedures parameterization is slower than scripts because stored prcedures can't use the same query plan if parameter change.
In other words, each time the parameter change, the SQL engine recompute the whole query instead using your cache.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |