Glen,
I've seen this many times. This probably due to the optimizer reusing plans. The QA by default recompiles the execution plan while the query passed by the QD reuses a previous queryplan
Look at the books online at the WITH RECOMPILE option. Create a SQL proc with recompile option as see whether this speed up things.
Walter,
>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?
>
>Glenn