I also tested this same query in VS.Net 2.0 from the Server tool and got a similar result as with VFP. I copied the query from the VS.Net query panel to the QA and it ran in less than a blink of the eye.
I am confused.
Glenn
>>I have an application written in VFP which executes a query against a SQL 2000 table with approx. 3,500,000 records. this table has an index on a computed field called Squeezedesc (replace(description,' ','') ).
>>
>>When I run this query in SQL Query Analyser it is done in negligible time whereas when executed from the app it takes 38 seconds???? Here is my query:
>>
>>Select inv.uid as idinv,inv.isbn13 as sku1 From inv Where SqueezeDesc like 'thehook%'
>>
>>
>>Is this an expected behavior?
>>
>
>Why would it be expected behavior?