What are the result of ctrl+l? Any table scans?

-----Original Message-----
From: David.Ekren
[mailto:mssqldba-ezmlmshield-x14683393.[Email address protected]
Sent: Monday, March 31, 2008 10:51 AM
To: LazyDBA Discussion
Subject: Comparing SQL times

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.
****************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page