Use the Index, Luke
use-the-index-luke.com
Use the Index, Luke
1–5 of 5 posts
Re: Use the Index, Luke
#2Over time I’ve found this site good for getting the basics across.
Re: Use the Index, Luke
#3As an SRE with a database background this should be required reading for any development team.
Re: Use the Index, Luke
#4[deleted]
Re: Use the Index, Luke
#5SQL indexing is definitely something I need to learn more about.
At the same time, it feels a bit like it's become such a standardised fallback approach that people will sometimes throw indexes at a problem instead of applying some thought to the query.
Admittedly, I'm basing this on a few personal anecdotes. For example, a long time ago an acquaintance posted a question on Facebook about speeding up a query in a database of astronomy data, where they were filtering based on a triangle-inequality style formula a^2 + b^2 c on the data before calculating the formula with squares. This apparently sped it up sufficiently for their purpose.