Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to check query statistics Expand / Collapse
Author
Message
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
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: Thursday, January 2, 2014 9:57 AM
Points: 554, Visits: 863

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