THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Defensive progr... » query performance   (RSS)
  • Yet another example of defensive query optimization

    My second take at the same problem I blogged about yesterday: To optimize a query, we frequently have to explicitly tell optimizer some information which it does not realize by itself. Short term, this works, but long term we run the risk that what we are telling to the optimizer may be no longer relevant. In the previous post, Optimizing a ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on February 18, 2010
Privacy Statement