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/en/multiple-column-indexes.html 📚 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: https://twitter.com/planetscaledata • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale/