在SELECT查询中使用TOP 1的性能效果

I have a User table where there are a Username and Application columns. Username may repeat but combination of Username + Application is unique, but I don't have the unique constraint set on the table (for performance) I have a User table where there are a Username