This obviously has big implications for performance. The lesson here is that if you’re going to write your own SQL query in the Query Editor, you should make sure it does all of the expensive filters ...

For example, OPTION (FAST n) tells SQL Server to prioritize returning the first 'n' rows quickly, which can be beneficial when displaying initial results to users. Proper use of query hints can ...