Ideagen Interview Question

Query optimisation — how would you approach improving slow database queries