|
Comments:
|
Jed Perlowin on 10/1/2009
A little more info on how this works as well as when to use it and when not to use it would have made this much more valuable.
|
|
|
good.it would be better if he explained much detail on executing the stored procedure
|
|
|
Perhaps a little mention of statistics and recompilation when using this option.
Christian Mark Jensen
DBA
|
|
|
useful technique
|
|
Steve Harris on 10/2/2009
Very helpful. Maybe mention the other option hints that can be used in the SELECT statement.
|
|
|
Here is a compare of this technique to other methods to solve parameter sniffing with more details: http://pratchev.blogspot.com/2007/08/parameter-sniffing.html. In essence when OPTIMIZE FOR UNKNOWN is used the optimizer uses statistical data to pick the execution plan. This may or may not be the best choice. This method does not force recompilation, but depends on statistics.
|
|
|
Could not understand the speaker. Would be nice to see the end results of the example query.
|
|
|
Thanks. Great hint.
|
|
Ralph Schwehr on 10/2/2009
had a hard time to understand him...
|
|
Derek Czarny on 10/5/2009
Should have shown how the Optimize for Unknown improves the query performance.
|
|
|
Hard to understand. Need to slow down when you talk.
|
|
|
Good explanation of to why use this option.
Thank you,
Tonci.
|
|
|
nice, but definitely language problem
|
|
Keith Wiggans on 6/14/2010
It would have been nice to have seen a comparison of the difference in execution plans caused by utilizing this query hint. Otherwise, A+ video. The author's accent is great.
|