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