Date: 2024-10-01
Time: 10:40–11:30
Room: Club Parlor
Level: Beginner
Feedback: Leave feedback
Are you indexing your table's columns? It's time to explore a different approach. Instead of simply indexing columns, consider indexing the specific values and ranges you will search for. While in a highly normalized schema, this typically translates to one or more columns, modern applications often require searching for criteria within a text fragment, an attribute within a JSON structure, or the maximum values across multiple rows. In this session, we will explore several examples and evaluate the effectiveness of indexing by examining the execution plan.
The following slides have been made available for this session: