Barclays Interview Question

how would you optimise your sql query? what tools would you use?