Jul 13, 2007 #1 katbear Programmer Mar 14, 2007 270 US Hi, Is it possible to run an estimated execution plan on a function? If not, how does one get around this? Thanks
Hi, Is it possible to run an estimated execution plan on a function? If not, how does one get around this? Thanks
Jul 13, 2007 #2 SQLDenis Programmer Oct 1, 2005 5,575 US you have to run the code that is in the function separately to get the plan Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQLBlog.com, Google Interview Questions Upvote 0 Downvote
you have to run the code that is in the function separately to get the plan Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQLBlog.com, Google Interview Questions
Jul 13, 2007 Thread starter #3 katbear Programmer Mar 14, 2007 270 US So, just highlight everything, then ctrl + L? Upvote 0 Downvote
Jul 13, 2007 #4 SQLDenis Programmer Oct 1, 2005 5,575 US >>So, just highlight everything, then ctrl + L? what is everything? you can't have the create function stuff there or what is inside you will have to strip the code out and run that by itself Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQLBlog.com, Google Interview Questions Upvote 0 Downvote
>>So, just highlight everything, then ctrl + L? what is everything? you can't have the create function stuff there or what is inside you will have to strip the code out and run that by itself Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQLBlog.com, Google Interview Questions