video1.0<iframe src="https://www.loom.com/embed/c5ec2a923ad945ab828bd7435c3f42f5" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/c5ec2a923ad945ab828bd7435c3f42f5-00001.gif176.582In 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.