http://blogs.msdn.com/ianjo/archive/2006/03/28/563419.aspxSQL 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, whichen-USCommunityServer 2.1 SP1 (Build: 61025.2)