Forum Discussion
What is the difference between OPTIMIZE FOR (@variable = value OR @variavel UNKOWN)
I was reading this https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008/ms181714(v=sql.100)?redirectedfrom=MSDN but I didn't found the difference between using: OPTION(OPTIMIZE...
OPTION(OPTIMIZE FOR (@dtini UNKNOWN, @dtfim UNKNOWN)) tells the query optimizer to optimize the query plan for unknown parameter values, meaning it will try to generate a query plan that will perform well for any parameter value that is passed in. This can be useful when the query is expected to be run with a variety of different parameter values. On the other hand, OPTION(OPTIMIZE FOR (@dtini = '2023-01-06', @dtfim = '2023-01-06')) specifies specific parameter values to the query optimizer. This tells the optimizer to generate a query plan specifically optimized for the values '2023-01-06' that are passed in for @dtini and @dtfim. This can be useful when you know the specific parameter values that will be used for the query, and you want to ensure that the query is optimized for those specific values.