Published On Sep 29, 2023
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:   / planetscaledata Â
• Discord:   / discord Â
• TikTok:   / planetscale Â
• Twitch:   / planetscale Â
• LinkedIn:   / planetscale Â