Post reply

How to check query statistics

  • May 14, 2010 at 4:46 am

    #386932

    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..

  • May 14, 2010 at 5:47 am

    #1167440

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply