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 |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2009-06-15 : 14:48:55
|
What is the best way to get the exectution plan of a function?I have a table-valued function that has about 15 small queries in it.I want to get the exectution plan on the small queries, but when I run:select * from [dbo].[fn_MyFunction]The execution plan just lumps the results into one.Any sugestions on the best way to get the detail of the execution?
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-15 : 14:55:20
|
Use SQL Profiler instead.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Actual Execution Plan of function.