Faster database indexes (straight from the docs)

Creating faster composite indexes via hashed columns! To learn more about PlanetScale, visit us at planetscale.com.

Link to the MySQL docs: https://dev.mysql.com/doc/refman/8.0/...

📚 Learn more about PlanetScale at https://planetscale.com/youtube.

——————————————————
00:00 MySQL documentation
00:58 Addresses table
02:17 Hash columns
04:13 concat vs concat_ws
05:40 Generated columns
07:31 The UNHEX function
09:34 Searching via hash
11:22 MD5 hash collisions
12:46 Functional indexes
——————————————————

💬 Follow PlanetScale on social media
• Twitter: Twitter: planetscaledata
• Discord: Discord: discord
• TikTok: TikTok: planetscale
• Twitch: Twitch: planetscale
• LinkedIn: LinkedIn: planetscale