I am running different queries in SQL Analyzer that all get the same
result sets, but with different indexes and different t-sql. Do I need
to clear the query cache or anything between running these queries to
make sure I am compare the execution times correctly? This is SQL 2000.

Thanks in advance,

David




****************************************************************
The information contained in this E-mail and any of its
attachments is intended only for the use of the address(es)
indicated above, and is confidential. This information may
also be legally privileged. If you are not the intended
recipient(s), you are hereby notified that any dissemination,
review or use of the information contained herein is
strictly prohibited. You may not copy, forward, disclose or use
any part of this information. If you have received this
information in error, please delete it and all copies from your
system and notify the sender immediately by return E-mail.

Thank you.

Internet communications are not always timely or
secure, and can contain errors and viruses. The sender does not
accept liability for any errors or omissions which arise as a
result.
****************************************************************

MS Sql Server LazyDBA home page