Debdutta Debdutta

Niner since 2017


  • SQL Server 2017 Adaptive QP

    In SQL Server 2014 New Cardinality Estimator has been introduced. It makes faster executions of lots of queries, but, we also observe slowness. Base on Microsoft recommendation, we use query hint Trace Flag 9481 (force to use old CE) and it worked as expected.

    My question is, does this great Adaptive Join feature solve this problem?