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 mofifiedAlan (alanpltse@.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, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp