Ideagen interview question

Query optimisation — how would you approach improving slow database queries