Pregunta de entrevista de Napier Healthcare

How do you optimize the SQL queries and Stored Procedures.