BUG: Optimizer May Ignore Index on Decimal or Numeric Column

ID: Q197241

The information in this article applies to:

BUG #: 17851 (SQLBUG_65)

SYMPTOMS

The query optimizer will not use an index on a decimal or a numeric column if the precision of the column does not match exactly the argument used in the WHERE clause for that column.

WORKAROUND

To work around this problem, ensure that the arguments used in the WHERE clause match the scale of the column exactly.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

MORE INFORMATION

This problem is most often noticed in situations where the column is specified with a scale of 0, because the argument in the WHERE clause will need to be specified with a decimal following the number (for example, "10." which is more often submitted as "10" or "10.0").

Additional query words: arg param parameter

Keywords          : SSrvISQL SSrvProg SSrvTran_SQL kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: December 13, 1998