UP Devlabs interview question

How can you optimize the SQL scripts in order to get report generated more efficiently?