Article ID: 248604 - View products that this article applies to.
This article was previously published under Q248604
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 55938 (SQLBUG_70)
The following query gives varying performance depending on the value you use for col6 in the BETWEEN clause:
A value lower than the one used in the BETWEEN clause must exist in the table. In the preceding example, col6 in TABLE1 must have a value lower than 1 or it will degrade performance.
Insert a dummy row in the table with a value for col6 that is lower than the one used in the BETWEEN clause.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0