title: Should I use OPTION (RECOMPILE) in a query that has several optional parameters
body: <p>I have a query used in a SSRS report with more than 20 optional filters. These filters generate a bunch of @PARAMETER IS NULL OR COLUMN = @PARAMETER in my query, which is known as a cause of performance problems.</p>
  
  <p>I've heard that OPTION (RECOMPILE) would cause SQL Server to analyze this conditions before generating the execution plan, so my question is: will it be a good option for this kind of query?</p>