Are SQL joins bad for performance?
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Write faster SQL today: https://databasestar.mykajabi.com/get...
Have you heard that SQL joins are bad and can slow down your queries? I've heard this too.
In this video, I'll demonstrate a query that joins three tables together along with the execution plan.
I'll also demonstrate the same query except all of the data is from one table, and the execution plan.
We'll then add some indexes and see what the execution plan looks like.
⏱ TIMESTAMPS:
00:00 - Our test
01:18 - Query 1
03:27 - Query 2
04:28 - Indexes
06:00 - Check both queries
LINKS:
The sample database (olympics) is available on GitHub here: https://github.com/bbrumm/databasesta...
The script for the queries used in this video: https://github.com/bbrumm/databasesta...
Watch video Are SQL joins bad for performance? online without registration, duration hours minute second in high quality. This video was added by user Database Star 19 September 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,223 once and liked it 323 people.