Stop using COUNT(id) to count rows
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
00:00 Intro
01:04 Origins of the myth
02:00 What does COUNT(*) mean?
02:30 COUNT(*) example
04:00 Primary and secondary indexes in MySQL
05:20 COUNT(id) example
——————————————————
💬 Follow PlanetScale on social media
• Twitter: / planetscaledata
• Discord: / discord
• TikTok: / planetscale
• Twitch: / planetscale
• LinkedIn: / planetscale