This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello. I wrote the code like the following, it was very slow. (use "Northwind" Database and LightSpeed 5.0.2370.0)
LightSpeed is generated to SQL the following.
But, SQL Server using the "Clustered Index Scan", execution cost is higher. I think by changing to a constant condition of WHERE, and the same result is obtained at low cost.
In the case, SQL Sever using the "Constant Scan", execution cost is lower. Best regards. |
|