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 mofifiedThis is clearly documented in Books Online. Please see "Execution Plan
Caching and Reuse"
Are you going to tell us what test you got this question from?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alan" <alanpltse@.yahoo.com.au> wrote in message
news:#2VJG0CcDHA.2392@.TK2MSFTNGP10.phx.gbl...
> 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
>|||Ans 3
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23gkH88CcDHA.620@.TK2MSFTNGP11.phx.gbl...
> This is clearly documented in Books Online. Please see "Execution Plan
> Caching and Reuse"
> Are you going to tell us what test you got this question from?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Alan" <alanpltse@.yahoo.com.au> wrote in message
> news:#2VJG0CcDHA.2392@.TK2MSFTNGP10.phx.gbl...
> > 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
> >
> >
>|||No fair after I told you exactly where to find the answer.
;-)
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#LvqXGDcDHA.1808@.TK2MSFTNGP11.phx.gbl...
> Ans 3
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23gkH88CcDHA.620@.TK2MSFTNGP11.phx.gbl...
> > This is clearly documented in Books Online. Please see "Execution Plan
> > Caching and Reuse"
> >
> > Are you going to tell us what test you got this question from?
> >
> > --
> > HTH
> > --
> > Kalen Delaney
> > SQL Server MVP
> > www.SolidQualityLearning.com
> >
> >
> > "Alan" <alanpltse@.yahoo.com.au> wrote in message
> > news:#2VJG0CcDHA.2392@.TK2MSFTNGP10.phx.gbl...
> > > 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
> > >
> > >
> >
> >
>|||You seem to be in a joyful mood today.. Long weekend huh ? :-)
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23pw9%23HDcDHA.1744@.TK2MSFTNGP12.phx.gbl...
> No fair after I told you exactly where to find the answer.
> ;-)
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:#LvqXGDcDHA.1808@.TK2MSFTNGP11.phx.gbl...
> > Ans 3
> >
> > "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> > news:%23gkH88CcDHA.620@.TK2MSFTNGP11.phx.gbl...
> > > This is clearly documented in Books Online. Please see "Execution Plan
> > > Caching and Reuse"
> > >
> > > Are you going to tell us what test you got this question from?
> > >
> > > --
> > > HTH
> > > --
> > > Kalen Delaney
> > > SQL Server MVP
> > > www.SolidQualityLearning.com
> > >
> > >
> > > "Alan" <alanpltse@.yahoo.com.au> wrote in message
> > > news:#2VJG0CcDHA.2392@.TK2MSFTNGP10.phx.gbl...
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>|||East coast I would presume..
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:u5Ejs7DcDHA.2960@.tk2msftngp13.phx.gbl...
> Gee, I didn't think it showed. I just got back from a 9 day vacation. I
only
> booted up my laptop on 3 of those days, and didn't check email once!
> (No electricity or cell towers, not to mention internet connectivity
> anywhere. -) )
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:#udqglDcDHA.456@.TK2MSFTNGP10.phx.gbl...
> > You seem to be in a joyful mood today.. Long weekend huh ? :-)
> >
> > "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> > news:%23pw9%23HDcDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > > No fair after I told you exactly where to find the answer.
> > >
> > > ;-)
> > >
> > > --
> > > HTH
> > > --
> > > Kalen Delaney
> > > SQL Server MVP
> > > www.SolidQualityLearning.com
> > >
> > >
> > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > news:#LvqXGDcDHA.1808@.TK2MSFTNGP11.phx.gbl...
> > > > Ans 3
> > > >
> > > > "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> > > > news:%23gkH88CcDHA.620@.TK2MSFTNGP11.phx.gbl...
> > > > > This is clearly documented in Books Online. Please see "Execution
> Plan
> > > > > Caching and Reuse"
> > > > >
> > > > > Are you going to tell us what test you got this question from?
> > > > >
> > > > > --
> > > > > HTH
> > > > > --
> > > > > Kalen Delaney
> > > > > SQL Server MVP
> > > > > www.SolidQualityLearning.com
> > > > >
> > > > >
> > > > > "Alan" <alanpltse@.yahoo.com.au> wrote in message
> > > > > news:#2VJG0CcDHA.2392@.TK2MSFTNGP10.phx.gbl...
> > > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>