{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/c5ec2a923ad945ab828bd7435c3f42f5\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/c5ec2a923ad945ab828bd7435c3f42f5-00001.gif","duration":176.582,"title":"Solving SQL Assignments on Indexing 🎯","description":"In this Loom, I explain how to solve SQL assignments on indexing. I provide a sample assignment that asks us to optimize fetching orders for a specific customer. The assignment requires us to modify the schema by creating an index on relevant columns to make the query faster. I demonstrate the process by editing the schema file on GitHub and creating an index on the product ID column in the orders table. I then explain how to commit the changes. Watch this video to learn how to solve similar SQL assignments and optimize queries using indexing."}