3 ms·
I work as a biostatistician and I've been tasked recently with querying large databases using SQL, in addition to analysing the data. However, my programming ba
by bioquestion 8y ago
I work as a biostatistician and I've been tasked recently with querying large databases using SQL, in addition to analysing the data. However, my programming background is very limited and thus I'm sure my queries are very inefficient.
Could you point me to some materials/texts about how to improve querying efficiency for SQL? If it's oriented for beginners then that would be ideal.
Thanks in advance.
- collyw 8y agoThis site is great. https://use-the-index-luke.com/ https://use-the-index-luke.com/
- bioquestion 8y agoThank you! I've already started reading it and it seems to be just what I needed.