Genworth interview question

Explain the various ways of optimising SQL Queries