Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ramnadh
Starting Member
23 Posts |
 Posted - 2004-09-17 : 14:51:45
|
| I am executing a stored procedure with out activating the execution Plan (Ctr + K)It is taking 2 sec. I want to optimize that query. To optimize that query i activated the execution plan and again run the stored procedure. It is taking about 12 sec. I doesn't know exactly whether the execution plan that was shown was correct or not. Can anyone tell me why it is happening so ? and the execution plan that was giving is correct or not ?Thanx,Ramnadh.Ramnadh |
|
|
Pat Phelan
Posting Yak Master
187 Posts |
Posted - 2004-09-17 : 17:45:42
|
| The estimated plan that is shown by Ctrl-L in Query Analyzer is a "best guess" at what might happen if the query was executed. The query plan enabled by Ctrl-K and shown after a procedure execution via Ctrl-E is a report of the plan that was actually used for that execution.-PatP |
 |
|
|
|
|
|
Checking Execution Plan