I was asked a question in interview.Suppose an employee table with columns ID,Name,Age,
Sex,Designation and there are lakhs of records.
Select Name,Age,Sex from Employee where Designation=@EmpDesignation.
WHat is alternative query to improve the performance on database.How can we do that
Thanks in advance