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