Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

execution plan

Status
Not open for further replies.
Saama5

Saama5

Programmer
Jan 6, 2002
52
US
Is there any way that Sql Server does not create execution plan for some sql queries which I am sure that I am not going to repeat them. Same way for Stored procedures, it should not keep in memory.
 
Sort by date Sort by votes
SQL must create a query plan for every query that is executed. There is no need to worry about retaining or not retaining them. SQL will manage procedure cache just fine. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
352
Chris Miller
Chris Miller
Crowley16
  • Locked
  • Question
Strange behaviour: include execution plan to improve performance
Replies
0
Views
111
Crowley16
Crowley16
RovirozM
  • Locked
  • Question
Execution Plan ? 1
Replies
3
Views
123
markros
markros
fredericofonseca
  • Locked
  • Question
Explain plan - KEY LOOKUP explanation
Replies
0
Views
114
fredericofonseca
fredericofonseca
GShen
  • Locked
  • Question
report execution
Replies
11
Views
197
GShen
GShen

Part and Inventory Search

Sponsor

Back
Top