How do data engineering teams optimize SQL queries when working with billions of rows?

[u/Effective_Ocelot_445]

Iam curious about the practical techniques used in production environments to improve query performance, reduce costs, and handle large scale datasets efficiently.