Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Upgrading cardinality RE: Upgrading cardinality

  • May 15, 2014 at 9:05 am

    #1713892

    Eirikur Eiriksson (5/15/2014)

    sestell1 (5/15/2014)

    Does anyone know if the trace flag should actually be 2312?

    I don't have a 2014 instance to test with. 🙁

    I'm getting slightly confused, ran queries with SHOWPLAN_XML on and both flags OPTION (QUERYTRACEON 9481) / OPTION (QUERYTRACEON 2312)

    The output indicates 2005 query plan for all instances, regardless of compatibility level.

    😎

    Maybe http://blogs.msdn.com/b/psssql/archive/2014/04/01/sql-server-2014-s-new-cardinality-estimator-part-1.aspx is yet anothet BOL page which misleads? Or has MS done something crazy like allowing the trace flags to cause the optimizer to switch to a different cardinality estimator version without recording it in the setting of the CardinalityEstimationModelVersion attribute in the xml plan?

    Tom