You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query takes too much time to return data. You need to improve the performance of the query. Which item should you add to the Salary column?
Martino88 is correct - the answer is an index. What would salary reference as a foreign key, as it is non-unique? Take these wrong answers with a grain of salt, but do learn from them.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
martino88
Highly Voted 5 years, 7 months agobcstokes
Highly Voted 4 years, 10 months agoMeshalx
Most Recent 2 years, 5 months agoAkakiusz
2 years, 5 months agodzoni68
2 years, 6 months agoAshurs
2 years, 7 months agocurtis_dmb
2 years, 8 months agoBottlecap
2 years, 10 months agoJJ12345678
3 years, 1 month agoMarc_01
3 years, 3 months agobongo2020
3 years, 6 months agoKameljt
3 years, 10 months agoCertMeUp
4 years, 2 months agogoodidea
4 years, 4 months ago