Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to check query statistics
Add to briefcase

How to check query statistics Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
gaurangtalwadkar
Posted Friday, May 14, 2010 4:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 17, 2010 6:02 AM
Points: 7, Visits: 23
I want to get query selectivity estimation from query statistics
I want to get selectivity before actually running the query..

can anybody tell me How to check query statistics..
Post #921902
deepak.a
Posted Friday, May 14, 2010 5:47 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, August 13, 2012 10:04 AM
Points: 554, Visits: 861

you mean you want disk activity Like Logical reads,phyical reads ..

Try the Below Option

SET STATISTICS IO ON

-- Query here

SET STATISTICS IO OFF

The above Option Displays information about the amount of disk activity that is generated by Transact-SQL statements after the statements execute. This SET option produces text output
Post #921925
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.