| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT
 F.FruitID,
 F.[Name],
 OJ.[key 1],
 OJ.[key 2],
 OJ.[key 3],
 OJ.[key 4],
 OJ.[key 5],
 F.[Description]
FROM dbo.Fruit AS F
CROSS APPLY OPENJSON
(
 -- Convert source data to JSON format
 '{' + 
 CHAR(34) + 
 REPLACE
 (
 REPLACE
 (
 CONVERT(varchar(max), F.Data), 
 '=', CHAR(34) + ':' + CHAR(34)
 ), 
 CHAR(13) + CHAR(10), 
 CHAR(34) + ',' + CHAR(34)
 ) + 
 CHAR(34) + 
 '}'
) 
WITH
(
 [key 1] varchar(100),
 [key 2] varchar(100),
 [key 3] varchar(100),
 [key 4] varchar(100),
 [key 5] varchar(100)
) AS OJ" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00406246" StatementEstRows="150" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xA10BA0C2DDF09559" QueryPlanHash="0x4DF964C8D4EB7012" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="208"><MemoryGrantInfo SerialRequiredMemory="32" SerialDesiredMemory="32" RequiredMemory="32" DesiredMemory="32" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="0" MaxQueryMemory="275784"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="779208"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-11-08T09:06:44.60" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_21B6055D]" Table="[Fruit]" Schema="[dbo]" Database="[fiddle_b412571c855248c896bcc0084c0e1037]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="150" EstimateIO="0" EstimateCPU="0.000627" AvgRowSize="531" EstimatedTotalSubtreeCost="0.00406246" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="FruitID"></ColumnReference><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Description"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 1"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 2"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 3"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 4"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 5"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Data"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="341" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="FruitID"></ColumnReference><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Data"></ColumnReference><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Description"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="FruitID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Data"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Description"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Index="[PK__Fruit__F33DDB2D0C68EFE1]" Alias="[F]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp><RelOp NodeId="2" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="50" EstimateIO="0" EstimateCPU="5.0157e-005" AvgRowSize="269" EstimatedTotalSubtreeCost="0.000150157" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 1"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 2"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 3"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 4"></ColumnReference><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 5"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3" InputMemoryGrant="1024" OutputMemoryGrant="1024" UsedMemoryGrant="0"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 4"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[OPENJSON_EXPLICIT]" Column="key 5"></ColumnReference></DefinedValue></DefinedValues><Object Table="[OPENJSON_EXPLICIT]"></Object><ParameterList><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(max),'{"'+replace(replace(CONVERT(varchar(max),[fiddle_b412571c855248c896bcc0084c0e1037].[dbo].[Fruit].[Data] as [F].[Data],0),'=',CONVERT_IMPLICIT(varchar(max),'":"',0)),'
',CONVERT_IMPLICIT(varchar(max),'","',0))+'"'+'}',0)"><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="'{"'"></Const></ScalarOperator><ScalarOperator><Intrinsic FunctionName="replace"><ScalarOperator><Intrinsic FunctionName="replace"><ScalarOperator><Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_b412571c855248c896bcc0084c0e1037]" Schema="[dbo]" Table="[Fruit]" Alias="[F]" Column="Data"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="'='"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="'":"'"></Const></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="'
'"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1001"><ScalarOperator><Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="'","'"></Const></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="'"'"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="'}'"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator ScalarString="N'$'"><Const ConstValue="N'$'"></Const></ScalarOperator><ScalarOperator ScalarString="N'$."key 1"'"><Const ConstValue="N'$."key 1"'"></Const></ScalarOperator><ScalarOperator ScalarString="N'$."key 2"'"><Const ConstValue="N'$."key 2"'"></Const></ScalarOperator><ScalarOperator ScalarString="N'$."key 3"'"><Const ConstValue="N'$."key 3"'"></Const></ScalarOperator><ScalarOperator ScalarString="N'$."key 4"'"><Const ConstValue="N'$."key 4"'"></Const></ScalarOperator><ScalarOperator ScalarString="N'$."key 5"'"><Const ConstValue="N'$."key 5"'"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |