Ian Jose's WebLog

This weblog is intended to help T-SQL developers get the best performing query plans from SQL Server. Some of the posts describe simple mistakes that can be easily avoided. Other posts describe complex solutions to limitations in SQL Server. Lastly, so
Translate This Page
Options
Search
  • Advanced search options...
Tags
No tags have been created or used yet.
Archive
Archives

March, 2006

MSDN Blogs > Ian Jose's WebLog > March, 2006
Posts
Sort by: Most Recent | Most Views | Most Comments
Excerpt View | Full Post View
  • Ian Jose's WebLog

    Disabling Constant-Constant Comparison Estimation

    Posted over 6 years ago
    by
    • 0 Comments
    SQL Server 8.0 did not perform cardinality estimates based on the comparion of two constants. Instead, SQL Server 8.0 guessed at the resulting selectivity. The reasoning for this is that one or more of the constants may be statement parameters, which...
Page 1 of 1 (1 items)