4 ms·
Good call linking to Use The Index Luke. A great resource. https://use-the-index-luke.com/ https://use-the-index-luke.com/
by eatonphil 3y ago
Good call linking to Use The Index Luke. A great resource.
https://use-the-index-luke.com/ https://use-the-index-luke.com/
- saikatsg 3y agoThanks for sharing!
- sherburt3 3y agoHis book SQL Performance Explained is also very enlightening as well. I think the most useful takeaway I got from that book is that the effectiveness of an index is heavily determined by how the application will be querying that table. If you want to design an effective index for a table you should experiment with multiple options and benchmark the queries that the application is going to run.