Creating faster composite indexes via hashed columns! To learn more about PlanetScale, visit us at planetscale.com.
Link to the MySQL docs: dev.mysql.com/doc/refman/8.0/...
📚 Learn more about PlanetScale at 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
Негізгі бет Ғылым және технология Faster database indexes (straight from the docs)
Пікірлер: 320