data-konzept

'If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So, if you are SQL Developer and your query run slow, you would prefer to have query execution statistics so that you can figure out what causing the query to run slow. To get the query execution statistics, you can use two useful “SET STATISTICS” commands;

• SET STATISTICS IO ON  – It provides the statistics details of I/O

• SET STATISTICS TIME ON  – It provides the statistics details of CPU'...

http://www.sqlservercentral.com/blogs/sql-geek/2017/11/06/getting-query-execution-statistics/?utm_source=DBW&utm_medium=pubemail