2 ms·
If this tickles you fancy, you should check out this site http://use-the-index-luke.com http://use-the-index-luke.com or a book by the same author https://www.a
by adamnemecek 10y ago
If this tickles you fancy, you should check out this site http://use-the-index-luke.com http://use-the-index-luke.com or a book by the same author https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826/ref=as_li_ss_tl?ie=UTF8&qid=1484664477&sr=8-1&keywords=Sql+performance&linkCode=ll1&tag=akhn-20&linkId=c4b9565b49e6d7df8926ea4b2c38638d https://www.amazon.com/Performance-Explained-Everything-Deve...
He goes into great detail to explain how exactly SQL indices work and how to leverage this to write queries.