Рет қаралды 24,197
Functional indexes and generated columns are a way to index things that aren't traditionally indexable, like JSON columns, data normalizations, or calculations.
To learn more about PlanetScale, head to planetscale.com/youtube!
Case insensitive searching video: kzfaq.info/get/bejne/g7JiZ6qD376qaas.html
Generated hash indexes video: kzfaq.info/get/bejne/a8eVradzxrTKk5c.html
--------
00:00 Functional indexes and generated columns
00:45 What is a functional index?
02:11 Example 1: Indexing the end of a string
05:05 Example 2: Case sensitive indexing
07:37 Example 3: Indexing a TEXT or BLOB
09:54 Example 4: Indexing a date part
12:57 Example 4.5: Indexing a date part, semantically
16:25 Example 5: Grouping by functional index
19:08 Example 6: Calculating age
21:09 Example 7: Data normalization
24:04 Example 8: Indexing a raw calculation
26:23 Example 9: Combining multiple statuses, and composite indexes
31:02 Example 10: Indexing JSON parts
--------
💬 Follow PlanetScale on social media
• Twitter: planetscale
• Discord: discord.gg/pDUGAAFEJx
• TikTok: www.tiktok.com/@planetscale
• Twitch: www.twitch.tv/planetscale
• LinkedIn: www.linkedin.com/company/planetscale