Managing correlated subqueries inside User-Defined Functions (UDFs) in Google BigQuery can be difficult, particularly when working with datasets that are changed often, like holiday flags. You may optimize your UDFs to efficiently calculate total delays by utilizing ARRAY_AGG and UNNEST in conjunction with good date handling approaches.