Simple Killer Queries

Recently we ran into an example of a ‘simple’ query that was doing an immense amount of work. There were a number of reasons behind this, but perhaps a better understanding of how indexes work, along with some critical questioning of what we were really trying to achieve could have helped.

For the full details and scintillating discussion on database query optimisation, you can visit our blog page at http://blog.ausvet.com.au.