Skip to content

Instantly share code, notes, and snippets.

@gilbonbaggins

gilbonbaggins/TF 2363.txt

Created February 12, 2020 21:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gilbonbaggins/71069128731a31d7d36d426c91a5d9a0 to your computer and use it in GitHub Desktop.
Save gilbonbaggins/71069128731a31d7d36d426c91a5d9a0 to your computer and use it in GitHub Desktop.
Download ZIP
TF 2363 Output for CE 120
Raw
TF 2363.txt
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
ScaOp_Logical x_lopAnd
ScaOp_Comp x_cmpNe
ScaOp_Identifier QCOL: [t].ItemID
ScaOp_Identifier COL: @ParentID
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [t].PermissionsFound
ScaOp_Const TI(tinyint,ML=1) XVAR(tinyint,Not Owned,Value=1)
Plan for computation:
CSelCalcCombineFilters_ExponentialBackoff (AND)
CSelCalcColumnInInterval
Column: QCOL: [t].PermissionsFound
CSelCalcColumnInInterval
Column: QCOL: [t].ItemID
Loaded histogram for column QCOL: [t].PermissionsFound from stats with id 3
Loaded histogram for column QCOL: [t].ItemID from stats with id 2
Selectivity: 0.999809
Stats collection generated:
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [i].ID
ScaOp_Identifier QCOL: [t].ItemID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [t].ItemID x_cmpEq QCOL: [i].ID )
Loaded histogram for column QCOL: [i].ID from stats with id 2
Selectivity: 1.16661e-009
Stats collection generated:
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [i].CreatorID
ScaOp_Identifier QCOL: [uc].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [i].CreatorID x_cmpEq QCOL: [uc].ID )
Loaded histogram for column QCOL: [i].CreatorID from stats with id 28
Loaded histogram for column QCOL: [uc].ID from stats with id 2
Selectivity: 2.54185e-007
Stats collection generated:
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [sl].StreamID
ScaOp_Identifier QCOL: [t].StreamID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [t].StreamID x_cmpEq QCOL: [sl].StreamID )
Loaded histogram for column QCOL: [t].StreamID from stats with id 4
Loaded histogram for column QCOL: [sl].StreamID from stats with id 6
Loaded histogram for column QCOL: [sl].StreamID from stats with id 7
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [sl].LockOwnerID x_cmpEq QCOL: [ul].ID )
Loaded histogram for column QCOL: [sl].LockOwnerID from stats with id 8
Loaded histogram for column QCOL: [sl].LockOwnerID from stats with id 11
Loaded histogram for column QCOL: [sl].LockOwnerID from stats with id 14
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].IsPrimary
ScaOp_Const TI(tinyint,ML=1) XVAR(tinyint,Not Owned,Value=1)
Plan for computation:
CSelCalcColumnInInterval
Column: QCOL: [ea].IsPrimary
Loaded histogram for column QCOL: [ea].IsPrimary from stats with id 5
Selectivity: 0.998819
Stats collection generated:
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [ea].UserID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Loaded histogram for column QCOL: [ea].UserID from stats with id 4
Scaling join selectivity up by 1.00061 to compensate for more distinct values in dimension than in fact
Selectivity: 2.54195e-007
Stats collection generated:
CStCollOuterJoin(ID=14, CARD=1.00071e+008 x_jtLeftOuter)
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
ScaOp_Const TI(bit,ML=1) XVAR(bit,Not Owned,Value=1)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollJoin(ID=15, CARD=2.05708e+010 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [i].CreatorID
ScaOp_Identifier QCOL: [uc].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [uc].ID x_cmpEq QCOL: [i].CreatorID )
Selectivity: 2.54185e-007
Stats collection generated:
CStCollJoin(ID=16, CARD=8.56988e+008 x_jtInner)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
Columns to distinct on:QCOL: [ea].UserID
Plan for computation:
CDVCPlanFilter
Overriding 0 columns
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 4
Using ambient cardinality 3.9322e+006 to combine distinct counts:
3.927e+006
Combined distinct count: 3.927e+006
Using ambient cardinality 3.9322e+006 to combine distinct counts:
3.927e+006
Combined distinct count: 3.927e+006
Result of computation: 3.927e+006
Estimating distinct count in utility function
Input stats collection:
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
Columns to distinct on:QCOL: [ul].ID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanUniqueKey
Result of computation: 3.93399e+006
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
Columns to distinct on:QCOL: [ea].IsPrimary
Plan for computation:
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 4
Using ambient cardinality 3.93684e+006 to combine distinct counts:
2
Combined distinct count: 2
Result of computation: 2
Estimating distinct count in utility function
Input stats collection:
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].LockOwnerID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 11
Using ambient cardinality 44 to combine distinct counts:
6.63325
Combined distinct count: 6.63325
Cap distinct counts using covering multi-col stats with id 11
Adjusted distinct count: 4
Result of computation: 5
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
Columns to distinct on:QCOL: [ul].ID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 3.93399e+006
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].StreamID
Plan for computation:
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 7
Using ambient cardinality 44 to combine distinct counts:
6.63325
Combined distinct count: 6.63325
Cap distinct counts using covering multi-col stats with id 7
Adjusted distinct count: 4
Result of computation: 4
Estimating distinct count in utility function
Input stats collection:
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
Columns to distinct on:QCOL: [t].StreamID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Left)
CDVCPlanJoin
Plan for non-join columns (Left)
CDVCPlanFilter
Overriding 0 columns
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Using ambient cardinality 5227.81 to combine distinct counts:
5227.81
Combined distinct count: 5227.81
Using ambient cardinality 5227.81 to combine distinct counts:
5227.81
Combined distinct count: 5227.81
Result of computation: 5227.81
Estimating distinct count in utility function
Input stats collection:
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
Columns to distinct on:QCOL: [i].CreatorID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 9
Using ambient cardinality 5228.03 to combine distinct counts:
4463.67
Combined distinct count: 4463.67
Result of computation: 4463.67
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
Columns to distinct on:QCOL: [uc].ID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 3.93399e+006
Estimating distinct count in utility function
Input stats collection:
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
Columns to distinct on:QCOL: [t].ItemID
Plan for computation:
CDVCPlanFilter
Overriding 1 columns
Using ambient cardinality 5229 to combine distinct counts:
5229
Combined distinct count: 5229
Result of computation: 5229
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
Columns to distinct on:QCOL: [i].ID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 8.57023e+008
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
Columns to distinct on:QCOL: [t].PermissionsFound
Plan for computation:
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Using ambient cardinality 5230 to combine distinct counts:
1
Combined distinct count: 1
Result of computation: 1
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
Columns to distinct on:QCOL: [t].ItemID
Plan for computation:
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Using ambient cardinality 5230 to combine distinct counts:
5230
Combined distinct count: 5230
Result of computation: 5230
Begin selectivity computation
Input tree:
LogOp_Join
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [sl].StreamID
ScaOp_Identifier QCOL: [t].StreamID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [t].StreamID x_cmpEq QCOL: [sl].StreamID )
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollJoin(ID=33, CARD=5227.81 x_jtInner)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_ApplyIdx TBL: dbo.StreamLock (3)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=34, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollOuterJoin(ID=35, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=34, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].LockID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanUniqueKey
Result of computation: 45
Loaded histogram for column QCOL: [sl].LockID from stats with id 1
Begin selectivity computation
Input tree:
LogOp_Join
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [sl].LockOwnerID x_cmpEq QCOL: [ul].ID )
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollJoin(ID=40, CARD=4.67413e+008 x_jtInner)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Selectivity: 2.54195e-007
Stats collection generated:
CStCollJoin(ID=44, CARD=9.99544e+007 x_jtInner)
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ea].UserID x_cmpEq QCOL: [ul].ID )
Selectivity: 2.54195e-007
Stats collection generated:
CStCollJoin(ID=46, CARD=1.00072e+008 x_jtInner)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollFudge(ID=12, CARD=1e+008)
CStCollOuterJoin(ID=11, CARD=4.67413e+008 x_jtLeftOuter)
CStCollOuterJoin(ID=10, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
Columns to distinct on:QCOL: [ea].UserID
Plan for computation:
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 4
Using ambient cardinality 3.93684e+006 to combine distinct counts:
3.9316e+006
Combined distinct count: 3.9316e+006
Result of computation: 3.9316e+006
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Intrinsic BitMapProbe
ScaOp_Identifier COL: Opt_Bitmap1010
ScaOp_Identifier QCOL: [i].CreatorID
Plan for computation:
CSelCalcBitmapFilter(0.99996, QCOL: [i].CreatorID)
Selectivity: 0.99996
Stats collection generated:
CStCollFilter(ID=49, CARD=8.56988e+008)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollFilter(ID=49, CARD=8.56988e+008)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [i].ID
ScaOp_Identifier QCOL: [t].ItemID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [t].ItemID x_cmpEq QCOL: [i].ID )
Selectivity: 1.16661e-009
Stats collection generated:
CStCollJoin(ID=50, CARD=5227.81 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollFilter(ID=49, CARD=8.56988e+008)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Logical x_lopAnd
ScaOp_Intrinsic BitMapProbe
ScaOp_Identifier COL: Opt_Bitmap1009
ScaOp_Identifier QCOL: [i].ID
ScaOp_Intrinsic BitMapProbe
ScaOp_Identifier COL: Opt_Bitmap1010
ScaOp_Identifier QCOL: [i].CreatorID
Plan for computation:
CSelCalcCombineFilters_Independence (AND)
CSelCalcBitmapFilter(6.10022e-006, QCOL: [i].ID)
CSelCalcBitmapFilter(0.99996, QCOL: [i].CreatorID)
Selectivity: 6.09997e-006
Stats collection generated:
CStCollFilter(ID=51, CARD=5227.81)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_HJwithBitMap
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollFilter(ID=51, CARD=5227.81)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [i].ID
ScaOp_Identifier QCOL: [t].ItemID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [t].ItemID x_cmpEq QCOL: [i].ID )
Selectivity: 1.16661e-009
Stats collection generated:
CStCollJoin(ID=52, CARD=5227.81 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollFilter(ID=51, CARD=5227.81)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
ScaOp_Intrinsic BitMapProbe
ScaOp_Identifier COL: Opt_Bitmap1011
ScaOp_Identifier QCOL: [i].ID
Plan for computation:
CSelCalcBitmapFilter(6.10022e-006, QCOL: [i].ID)
Selectivity: 6.10022e-006
Stats collection generated:
CStCollFilter(ID=53, CARD=5228.03)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollJoin(ID=16, CARD=8.56988e+008 x_jtInner)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
Columns to distinct on:QCOL: [i].ID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 8.56988e+008
Begin selectivity computation
Input tree:
LogOp_ApplyIdx TBL: dbo.StreamLock (3)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=62, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollOuterJoin(ID=63, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=62, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].LockID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 44
Estimating distinct count in utility function
Input stats collection:
CStCollFilter(ID=53, CARD=5228.03)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
Columns to distinct on:QCOL: [i].ID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 5228.03
Estimating distinct count in utility function
Input stats collection:
CStCollJoin(ID=52, CARD=5227.81 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollFilter(ID=51, CARD=5227.81)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
Columns to distinct on:QCOL: [i].CreatorID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanFilter
Overriding 0 columns
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 9
Using ambient cardinality 0.0318908 to combine distinct counts:
0.0318886
Using ambient cardinality 1 to combine distinct counts:
0.0318908
Result of computation: 1
Estimating distinct count in utility function
Input stats collection:
CStCollJoin(ID=50, CARD=5227.81 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollFilter(ID=49, CARD=8.56988e+008)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
Columns to distinct on:QCOL: [i].CreatorID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanFilter
Overriding 0 columns
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 9
Using ambient cardinality 5227.81 to combine distinct counts:
4463.63
Combined distinct count: 4463.63
Using ambient cardinality 5227.81 to combine distinct counts:
4463.63
Combined distinct count: 4463.63
Result of computation: 4463.63
Begin selectivity computation
Input tree:
LogOp_ApplyIdx TBL: dbo.StreamLock (3)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=87, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollOuterJoin(ID=88, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=87, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_ApplyIdx TBL: dbo.StreamLock (3)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=102, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollOuterJoin(ID=103, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=102, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_ApplyIdx TBL: dbo.StreamLock (3)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=105, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollOuterJoin(ID=106, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=105, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [sl].LockOwnerID x_cmpEq QCOL: [ul].ID )
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [sl].StreamID
ScaOp_Identifier QCOL: [t].StreamID
Plan for computation:
CSelCalcHistogramComparison(POINT PREDICATE)
Calculator failed. Replanning.
Plan for computation:
CSelCalcGuessInList(1 values in in-list)
Selectivity: 0.01
Stats collection generated:
CStCollFilter(ID=112, CARD=100)
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [sl].StreamID
ScaOp_Identifier QCOL: [t].StreamID
Plan for computation:
CSelCalcHistogramComparison(POINT PREDICATE)
Calculator failed. Replanning.
Plan for computation:
CSelCalcGuessInList(1 values in in-list)
Selectivity: 0.150756
Stats collection generated:
CStCollFilter(ID=113, CARD=6.63325)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Scaling join selectivity up by 1.00061 to compensate for more distinct values in dimension than in fact
Scaling join selectivity up by 1.00061 to compensate for more distinct values in dimension than in fact
Selectivity: 2.54349e-007
Stats collection generated:
CStCollOuterJoin(ID=114, CARD=10013.2 x_jtLeftOuter)
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Scaling join selectivity up by 1.00046 to compensate for more distinct values in dimension than in fact
Scaling join selectivity up by 1.00072 to compensate for more distinct values in dimension than in fact
Selectivity: 2.54311e-007
Stats collection generated:
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcHistogramComparison(POINT PREDICATE)
Selectivity: 2.54195e-007
Stats collection generated:
CStCollFilter(ID=116, CARD=1.00105)
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcUniqueKeyFilter
Selectivity: 2.54195e-007
Stats collection generated:
CStCollFilter(ID=117, CARD=1)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_LeftOuterJoin
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [sl].LockOwnerID x_cmpEq QCOL: [ul].ID )
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollOuterJoin(ID=118, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Select
CStCollOuterJoin(ID=118, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [sl].StreamID
ScaOp_Identifier QCOL: [t].StreamID
Plan for computation:
CSelCalcHistogramComparison(POINT PREDICATE)
Calculator failed. Replanning.
Plan for computation:
CSelCalcGuessInList(1 values in in-list)
Selectivity: 0.000503912
Stats collection generated:
CStCollFilter(ID=119, CARD=1984.47)
CStCollOuterJoin(ID=118, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollFilter(ID=113, CARD=6.63325)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].LockOwnerID
Plan for computation:
CDVCPlanFilter
Overriding 0 columns
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 11
Using ambient cardinality 6.63325 to combine distinct counts:
2.57551
Combined distinct count: 2.57551
Using ambient cardinality 6.63325 to combine distinct counts:
2.57551
Combined distinct count: 2.57551
Result of computation: 2.57551
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFilter(ID=117, CARD=1)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Selectivity: 2.54349e-007
Stats collection generated:
CStCollJoin(ID=121, CARD=1.00015 x_jtInner)
CStCollFilter(ID=117, CARD=1)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollFilter(ID=117, CARD=1)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ea].UserID x_cmpEq QCOL: [ul].ID )
Selectivity: 2.54349e-007
Stats collection generated:
CStCollJoin(ID=123, CARD=1.00133 x_jtInner)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollFilter(ID=117, CARD=1)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollFilter(ID=117, CARD=1)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
Columns to distinct on:QCOL: [ul].ID
Plan for computation:
CDVCPlanTrivial
Result of computation: 1
Estimating distinct count in utility function
Input stats collection:
CStCollFudge(ID=34, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].LockID
Plan for computation:
CDVCPlanUniqueKey
Result of computation: 1
Estimating distinct count in utility function
Input stats collection:
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
Columns to distinct on:QCOL: [ul].ID
Plan for computation:
CDVCPlanRedundantOJ
Delegating to left
CDVCPlanUniqueKey
Result of computation: 3.93399e+006
Begin selectivity computation
Input tree:
LogOp_ApplyIdx TBL: dbo.StreamLock (3)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=135, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Plan for computation:
CSelCalcFixedJoin (1)
Selectivity: 1
Stats collection generated:
CStCollOuterJoin(ID=136, CARD=5227.81 x_jtLeftOuter)
CStCollJoin(ID=9, CARD=5227.81 x_jtInner)
CStCollJoin(ID=8, CARD=5228.03 x_jtInner)
CStCollFilter(ID=7, CARD=5229)
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
CStCollBaseTable(ID=2, CARD=8.57023e+008 TBL: dbo.Items AS TBL: i)
CStCollBaseTable(ID=3, CARD=3.93399e+006 TBL: dbo.Users AS TBL: uc)
CStCollFudge(ID=135, CARD=1)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Scaling join selectivity up by 1.00046 to compensate for more distinct values in dimension than in fact
Selectivity: 2.54311e-007
Stats collection generated:
CStCollJoin(ID=139, CARD=3.93399e+006 x_jtInner)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ea].UserID x_cmpEq QCOL: [ul].ID )
Selectivity: 2.54195e-007
Stats collection generated:
CStCollJoin(ID=141, CARD=3.93684e+006 x_jtInner)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollOuterJoin(ID=118, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollOuterJoin(ID=115, CARD=3.93814e+006 x_jtLeftOuter)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
Columns to distinct on:QCOL: [sl].StreamID
Plan for computation:
CDVCPlanRedundantOJ
Delegating to left
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 7
Using ambient cardinality 44 to combine distinct counts:
6.63325
Combined distinct count: 6.63325
Cap distinct counts using covering multi-col stats with id 7
Adjusted distinct count: 4
Result of computation: 4
Estimating distinct count in utility function
Input stats collection:
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
Columns to distinct on:QCOL: [sl].LockOwnerID
Plan for computation:
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 11
Using ambient cardinality 44 to combine distinct counts:
6.63325
Combined distinct count: 6.63325
Cap distinct counts using covering multi-col stats with id 11
Adjusted distinct count: 4
Result of computation: 4
Estimating distinct count in utility function
Input stats collection:
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
Columns to distinct on:QCOL: [ul].ID
Plan for computation:
CDVCPlanJoin
Plan for non-join columns (Right)
CDVCPlanUniqueKey
Result of computation: 10000
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [sl].LockOwnerID x_cmpEq QCOL: [ul].ID )
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollJoin(ID=148, CARD=3.93399e+006 x_jtInner)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ul].ID x_cmpEq QCOL: [ea].UserID )
Scaling join selectivity up by 1.00061 to compensate for more distinct values in dimension than in fact
Selectivity: 2.54349e-007
Stats collection generated:
CStCollJoin(ID=152, CARD=10001.5 x_jtInner)
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
CStCollFilter(ID=13, CARD=3.9322e+006)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ea].UserID
ScaOp_Identifier QCOL: [ul].ID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [ea].UserID x_cmpEq QCOL: [ul].ID )
Scaling join selectivity up by 1.00061 to compensate for more distinct values in dimension than in fact
Selectivity: 2.54349e-007
Stats collection generated:
CStCollJoin(ID=154, CARD=10013.3 x_jtInner)
CStCollBaseTable(ID=6, CARD=3.93684e+006 TBL: dbo.EmailAddresses AS TBL: ea)
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Begin selectivity computation
Input tree:
LogOp_Join
CStCollFilter(ID=113, CARD=6.63325)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
ScaOp_Comp x_cmpEq
ScaOp_Identifier QCOL: [ul].ID
ScaOp_Identifier QCOL: [sl].LockOwnerID
Plan for computation:
CSelCalcExpressionComparedToExpression( QCOL: [sl].LockOwnerID x_cmpEq QCOL: [ul].ID )
Calculator failed. Replanning.
Plan for computation:
CSelCalcSimpleJoin (Using base cardinality)
Selectivity: 0.0227273
Stats collection generated:
CStCollJoin(ID=176, CARD=593071 x_jtInner)
CStCollFilter(ID=113, CARD=6.63325)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
End selectivity computation
Estimating distinct count in utility function
Input stats collection:
CStCollFudge(ID=111, CARD=10000)
CStCollOuterJoin(ID=110, CARD=3.93399e+006 x_jtLeftOuter)
CStCollBaseTable(ID=4, CARD=44 TBL: dbo.StreamLock AS TBL: sl)
CStCollBaseTable(ID=5, CARD=3.93399e+006 TBL: dbo.Users AS TBL: ul)
Columns to distinct on:QCOL: [sl].StreamID
Plan for computation:
CDVCPlanRedundantOJ
Delegating to left
CDVCPlanLeaf
0 Multi-Column Stats, 1 Single-Column Stats, 0 Guesses
Covering multi-col stats id: 7
Using ambient cardinality 44 to combine distinct counts:
6.63325
Combined distinct count: 6.63325
Cap distinct counts using covering multi-col stats with id 7
Adjusted distinct count: 4
Result of computation: 4
Completion time: 2020-02-12T14:48:50.1947548-05:00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment