Optimizing query to fetch records from employee table based on city

• Create an index on the City column

• Use a WHERE clause with an index hint

• Use a stored procedure to cache the query results

• Use a materia...read more