UP Devlabs Interview Question

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