.

StmtTextStmtIdNodeIdParentPhysicalOpLogicalOpArgumentDefinedValuesEstimateRowsEstimateIOEstimateCPUAvgRowSizeTotalSubtreeCostOutputListWarningsTypeParallelEstimateExecutions

.

select * from t where c2 < 1048576 or c2 is null110NULLNULL1NULL250119.4NULLNULLNULL0.5991541NULLNULLSELECT0NULL

.

|--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1010], [Expr1011], [Expr1012]))121Nested LoopsInner JoinOUTER REFERENCES:([Expr1010], [Expr1011], [Expr1012])NULL250119.40.32386570.2752884150.5991541[Test].[dbo].[t].[c1], [Test].[dbo].[t].[c2]NULLPLAN_ROW01

.

|--Merge Interval132Merge IntervalMerge IntervalNULLNULL200190[Expr1010], [Expr1011], [Expr1012]NULLPLAN_ROW01

.

| |--Sort(TOP 2, ORDER BY:([Expr1013] DESC, [Expr1014] ASC, [Expr1010] ASC, [Expr1015] DESC))143SortTopN SortTOP 2, ORDER BY:([Expr1013] DESC, [Expr1014] ASC, [Expr1010] ASC, [Expr1015] DESC)NULL200190[Expr1010], [Expr1011], [Expr1012], [Expr1013], [Expr1014], [Expr1015]NULLPLAN_ROW01

.

| |--Compute Scalar(DEFINE:([Expr1013]=((4)&[Expr1012]) = (4) AND NULL = [Expr1010], [Expr1014]=(4)&[Expr1012], [Expr1015]=(16)&[Expr1012]))154Compute ScalarCompute ScalarDEFINE:([Expr1013]=((4)&[Expr1012]) = (4) AND NULL = [Expr1010], [Expr1014]=(4)&[Expr1012], [Expr1015]=(16)&[Expr1012])[Expr1013]=((4)&[Expr1012]) = (4) AND NULL = [Expr1010], [Expr1014]=(4)&[Expr1012], [Expr1015]=(16)&[Expr1012]200190[Expr1010], [Expr1011], [Expr1012], [Expr1013], [Expr1014], [Expr1015]NULLPLAN_ROW01

.

| |--Concatenation165ConcatenationConcatenationNULL[Expr1010] = ([Expr1005], [Expr1008]), [Expr1011] = ([Expr1006], [Expr1009]), [Expr1012] = ([Expr1004], [Expr1007])200190[Expr1010], [Expr1011], [Expr1012]NULLPLAN_ROW01

.

| |--Compute Scalar(DEFINE:([Expr1005]=NULL, [Expr1006]=NULL, [Expr1004]=(60)))176Compute ScalarCompute ScalarDEFINE:([Expr1005]=NULL, [Expr1006]=NULL, [Expr1004]=(60))[Expr1005]=NULL, [Expr1006]=NULL, [Expr1004]=(60)100190[Expr1005], [Expr1006], [Expr1004]NULLPLAN_ROW01

.

| | |--Constant Scan187Constant ScanConstant ScanNULLNULL10000NULLNULLPLAN_ROW01

.

| |--Compute Scalar(DEFINE:([Expr1008]=NULL, [Expr1009]=(1048576), [Expr1007]=(10)))1166Compute ScalarCompute ScalarDEFINE:([Expr1008]=NULL, [Expr1009]=(1048576), [Expr1007]=(10))[Expr1008]=NULL, [Expr1009]=(1048576), [Expr1007]=(10)100190[Expr1008], [Expr1009], [Expr1007]NULLPLAN_ROW01

.

| |--Constant Scan11716Constant ScanConstant ScanNULLNULL10000NULLNULLPLAN_ROW01

.

|--Index Seek(OBJECT:([Test].[dbo].[t].[i]), SEEK:([Test].[dbo].[t].[c2] > [Expr1010] AND [Test].[dbo].[t].[c2] < [Expr1011]) ORDERED FORWARD)1322Index SeekIndex SeekOBJECT:([Test].[dbo].[t].[i]), SEEK:([Test].[dbo].[t].[c2] > [Expr1010] AND [Test].[dbo].[t].[c2] < [Expr1011]) ORDERED FORWARD[Test].[dbo].[t].[c1], [Test].[dbo].[t].[c2]250119.40.32386570.2752884150.5991541[Test].[dbo].[t].[c1], [Test].[dbo].[t].[c2]NULLPLAN_ROW01