Easy database indexing strategies

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: MySQL case insensitive searching (don...
Generated hash indexes video: Faster database indexes (straight fro...

--------
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: Twitter: planetscale
• Discord: Discord: discord
• TikTok: TikTok: planetscale
• Twitch: Twitch: planetscale
• LinkedIn: LinkedIn: planetscale