471,073 Members | 1,367 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Execution plan

Which of the following does NOT cause the execution plan of a query to be
recompiled ?

- new column is added to a table accessed by a query OR
- index used by a query has been dropped from the database OR
- query perfoms a join to return data from multiple tables OR
- significant amount of data in a table has been mofified
Jul 20 '05 #1
1 1930
Alan (al*******@yahoo.com.au) writes:
Which of the following does NOT cause the execution plan of a query to be
recompiled ?

- new column is added to a table accessed by a query OR
- index used by a query has been dropped from the database OR
- query perfoms a join to return data from multiple tables OR
- significant amount of data in a table has been mofified


Could you elaborate why you ask?

That is, this looks like question from a test or an assignment, and we are
a bit reluctant to answer such questions here, thinking that you are best
served by finding out the answer yourself.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Dan | last post: by
1 post views Thread by Martin Kraus | last post: by
2 posts views Thread by Marie | last post: by
2 posts views Thread by Jenny Zhang | last post: by
2 posts views Thread by Ina Schmitz | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.