Join Optimizations with BigQuery Primary and Foreign Keys | Google Cloud Blog
Understand how unenforced Key Constraints can benefit queries in BigQuery.
cloud.google.com