Can you tell me what is difference between OPTION (USE HINT('DISABLE_PARAMETER_SNIFFING')) and OPTION (OPTIMIZE FOR UNKNOWN)?

  • What SQL platform and version are you referring to? Did you find any information on those hints online already and what pieces did or didn't make sense between them? – Shaulinator May 16 '18 at 16:40
  • you can take a look at the following link from Microsoft Documentation – Eduardo Pivaral May 16 '18 at 18:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.