How to measure performance of Queries? 

1 SET LANGUAGE ENGLISH
2 SET STATISTICS TIME ON
3 SET STATISTICS IO ON
4 
5 
6 PRINT 'Result of first Query'
7 Your first Query
8 PRINT 'Result of second Query'
9 Your second Query


Reference

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)