Created
February 12, 2020 21:13
-
-
Save gilbonbaggins/71069128731a31d7d36d426c91a5d9a0 to your computer and use it in GitHub Desktop.
TF 2363 Output for CE 120
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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