This Query Ran 5,100 Times a Day. Nobody Had Noticed.
Database Star
???? Get the SQL Performance Checklist: https://databasestar.mykajabi.com/lpkj-performance-checklist/?video=-hLsj3JkX0I
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/zPYFUthD/checkout?video=-hLsj3JkX0I
In this video, I'll explain a problematic query I found at work, why it was a problem, and how I fixed it.
TIMESTAMPS:
00:00 - The query
01:56 - The execution plan
04:02 - Investigating the data
08:12 - A bonus improvement
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/zPYFUthD/checkout?video=-hLsj3JkX0I
In this video, I'll explain a problematic query I found at work, why it was a problem, and how I fixed it.
TIMESTAMPS:
00:00 - The query
01:56 - The execution plan
04:02 - Investigating the data
08:12 - A bonus improvement
0 Comments
No comments yet. Be the first to weigh in.