Date: 2024-10-01
Time: 10:40–11:30
Room: Club Parlor
Level: Beginner
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.