Welcome to an introduction on database performance tuning and optimisation. My previous tutorial, SQL Made Simple, looked at a normalised database, and explored some of the queries we would use to make information from data in its normalised state. Today, we’re going to look at ways to shorten query processing time on this same database.

Read more>>