SQL Like a Pro: Query Tuning #1
If you ever got fed up with queries that run for hours… this one is for you!
I started tuning SQL queries very early in my career, being that ETL scripts or business user queries. There was something highly rewarding about taking a SQL query runtime from 10 minutes to 30 seconds, and deep diving into how the database worked, understanding its core query…