Is the query well optimized

Question

Dear All,

According to the design of the index, is the following query well optimized?

sSql = "Select Top 1 SubjectID, CourseID, EnrolDate, Absence, Remark from Course Order by StudentID = 38

Answer 1

I think you're missing a where clause.
Select Top 1 SubjectID, CourseID, EnrolDate, Absence, Remark from Course Where StudentID = 38
Because you filter by StudentID 38 you don't need to order by it. After that, the Query should be fine since StudentID is part of the primary key, so SQL Server should use index seek to look for the enry.

Answer 2

Hi Christopher,

Thanks for your reply.