ohgodno.txt

Begin selectivity computation

Input tree:

  LogOp_Select

      CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

      ScaOp_Comp x_cmpEq

          ScaOp_Identifier QCOL: [AdventureWorks2012_CS].[Person].[Address].StateProvinceID

          ScaOp_Identifier COL: @StateProvinceID 

Plan for computation:

  CSelCalcHistogramComparison(POINT PREDICATE)

Loaded histogram for column QCOL: [AdventureWorks2012_CS].[Person].[Address].StateProvinceID from stats with id 4

Selectivity: 0.0135135

Stats collection generated: 

  CStCollFilter(ID=2, CARD=265.054)

      CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

End selectivity computation

Begin distinct values computation

Input tree:

  LogOp_GbAgg OUT(QCOL: [AdventureWorks2012_CS].[Person].[Address].City,) BY(QCOL: [AdventureWorks2012_CS].[Person].[Address].City,)

      CStCollFilter(ID=2, CARD=265.054)

          CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

      AncOp_PrjList 

Plan for computation:

  CDVCPlanFilter

      Overriding 0 columns

      CDVCPlanLeaf

          0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses

          Covering multi-col stats id: 3

Loaded histogram for column QCOL: [AdventureWorks2012_CS].[Person].[Address].City from stats with id 5

Using ambient cardinality 265.054 to combine distinct counts:

  150.762

Combined distinct count: 150.762

Using ambient cardinality 265.054 to combine distinct counts:

  150.762

Combined distinct count: 150.762

Result of computation: 150.762

Stats collection generated: 

  CStCollGroupBy(ID=3, CARD=150.762)

      CStCollFilter(ID=2, CARD=265.054)

          CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

End distinct values computation

Begin distinct values computation

Input tree:

  LogOp_GbAgg<local> OUT(QCOL: [AdventureWorks2012_CS].[Person].[Address].City,) BY(QCOL: [AdventureWorks2012_CS].[Person].[Address].City,)

      CStCollFilter(ID=2, CARD=265.054)

          CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

      AncOp_PrjList 

Plan for computation:

  CDVCPlanFilter

      Overriding 0 columns

      CDVCPlanLeaf

          0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses

          Covering multi-col stats id: 3

Using ambient cardinality 265.054 to combine distinct counts:

  150.762

Combined distinct count: 150.762

Using ambient cardinality 265.054 to combine distinct counts:

  150.762

Combined distinct count: 150.762

Result of computation: 150.762

After adjustment for parallelism: 212.606

Stats collection generated: 

  CStCollGroupBy(ID=4, CARD=212.606)

      CStCollFilter(ID=2, CARD=265.054)

          CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

End distinct values computation

Estimating distinct count in utility function

Input stats collection:

    CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

Columns to distinct on:QCOL: [AdventureWorks2012_CS].[Person].[Address].StateProvinceID


Plan for computation:

  CDVCPlanLeaf

      0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses

      Covering multi-col stats id: 3

Using ambient cardinality 19614 to combine distinct counts:

  74

Combined distinct count: 74

Result of computation: 74