Napier Healthcare interview question

How do you optimize the SQL queries and Stored Procedures.