Post reply

DMV Problem - dm_exec_query_stats

  • April 5, 2012 at 10:07 am

    #1469672

    Could you confirm if selecting data from a view would automatically cause a recompilation? Or would it depened on the tables which the view references?

  • April 5, 2012 at 10:42 am

    #1469700

    ggjjbb1983 (4/5/2012)

    Is there any reason why a sample scan would be performed instead of a full scan?

    I may be guessing it wrong here but maybe it's because a statistics update would take a lot of resources with large tables?

    Thank you for the link to the article, Gail. Very informative and interesting.

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

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

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