I have been tasked with improving the performance of a query which is part
of a Delphi program to which I do not have the source. Using profile while
the program is running I identified the query and copied it to the Query
Analyser to work on it.

By creating an index on a certain field I managed to reduce the time in QA
from 58secs to 120ms. However, when I created the new index on the server
and ran the executable exactly as before but it does not use the new index.

How do I make the query use the new index?

thanks in advance

David Lee
DBA
Carlson Marketing
This message and any attachment are intended for use only by the individual to whom they are specifically addressed above, and may contain privileged or
confidential information. Any unauthorized dissemination or copying of this message or any attachment, and any use or disclosure of any information contained in
them, is strictly prohibited and may be illegal. If you are not the intended recipient of this message, please notify the sender immediately and delete it from any
computer.

Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the company
MS Sql Server LazyDBA home page