|
Slide deck and discussion re July 07 meeting - Understanding Execution Plans (Greg Linwood)
Posted: 17 Jul 2007 10:31 PM |
A copy of the slide deck for tonight's Melbourne SQL User Group presentation has been uploaded here:
http://www.sqlserver.org.au/meetings/Melb/2007/
If anyone has any questions or issues they'd like to discuss about the presentation or this topic in general please post here & I'll monitor this thread + try to respond asap.
Regards,
Greg Linwood |
|
|
 |
|
 mr_fj
|
 |
| Joined: 30 Jan 2007 |
| Total Posts: 2 |
| |
|
Re: Slide deck and discussion re July 07 meeting - Understanding Execution Plans (Greg Linwood)
Posted: 18 Jul 2007 10:05 AM |
Hi Greg,
I had a query where I fine-tuned the query in the Query Analyser and it took 3mins to run, but after I moved the code to SP and the fine-tuning didn't work (it took more than an hour to run).
In ran the profiler with Execution Plan event on and found that the hints I gave is not used once inside the sp.
This particular select statement is one of many statements that populate a temp table inside the sp.
Do you have any idea as to why this is happening?
I got around this problem by running this piece of code using sp_ExecuteSQL but not sure that this is the best way to go about.
Thank you.
Kind regards,
Fredy
|
|
|
|
|