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 https://planetscale.com/youtube!
Case insensitive searching video: https://www.youtube.com/watch?v=ML24GRzXF9w
Generated hash indexes video: https://www.youtube.com/watch?v=5aezDBaNfcc
--------
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: https://twitter.com/planetscale
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale