Execution plan

[Alan]

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

[Erland Sommarskog]

Re: Execution plan

Alan (alanpltse@yaho o.com.au) writes:[color=blue]
> 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[/color]

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/techinfo/productdoc/2000/books.asp