Question d’entretien chez Napier Healthcare

How do you optimize the SQL queries and Stored Procedures.