View the statement execution plan:

The set showplan on
The set noexec on
Go
The select...
Go
The set showplan off
The set noexec off
Go

Want to ask next, select is check which table, have a great spirit in you,

CodePudding user response:

Execution plan result is similar to the print output, you can use the built-in query analyzer to try