From the course: Advanced SQL for Data Scientists
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Challenge: Choosing an optimal indexing strategy
From the course: Advanced SQL for Data Scientists
Challenge: Choosing an optimal indexing strategy
(bright music) - [Instructor] Alright, here's a challenge around indexing. Let's assume you have received a large dataset with insurance claims details. Now you want to be able to upload or ingest that data into an existing database that you're already using for your data science analytics. Now each claim has a unique claim identifier along with about 12 columns of data. The existing database has a table of all claim numbers ever generated. How would you index the new claims detailed to optimize a join operation on the claim ID?
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.