<?xml version="1.0" encoding="UTF-8"?>
<query>
	<planVersion> 1.0 </planVersion>
	<statementNum>1</statementNum>
	<lineNum>1</lineNum>
	<text>
		<![CDATA[
			SQL Text: SELECT uid, gid, hashkey, id, sequence, exec_min, exec_max, exec_avg, elap_min, elap_max, elap_avg, lio_min, lio_max, lio_avg, pio_min, pio_max, pio_avg, cnt, abort_cnt, qtext  
			 
			        FROM dbo.sysquerymetrics 
			
		]]>
	</text>
	<abstractPlan>
		<![CDATA[>
		( nl_join ( i_scan ncsysqueryplans ( table ( a sysqueryplans ) ) ) ( i_scan csysqueryplans ( table ( b sysqueryplans ) ) ) ) ( prop ( table ( a sysqueryplans ) ) ( parallel 1 ) ( prefetch 4 ) ( lru ) ) ( prop ( table ( b sysqueryplans ) ) ( parallel 1 ) ( prefetch 4 ) ( lru ) ) 
		]]>
	</abstractPlan>
	<costs>
		<lio> 6 </lio>
		<pio> 5.999998 </pio>
		<cpu> 8 </cpu>
	</costs>
	<resource>
		<threads> 0 </threads>
		<auxSdes>0</auxSdes>
	</resource>
	<optimizerMetrics>
		<optTimeMs>2521428102362431488</optTimeMs>
		<optTicks>2521428102362431488</optTicks>
		<plansEvaluated>2</plansEvaluated>
		<plansValid>1</plansValid>
		<procCacheBytes>159744</procCacheBytes>
	</optimizerMetrics>
	<optimizerStatistics>
		<statInfo>
			<objName>sysqueryplans</objName>
			<missingHistogram>
				<column>uid</column>
				<column>gid</column>
				<column>id</column>
				<column>type</column>
			</missingHistogram>
			<missingDensity>
				<column>uid</column>
				<column>gid</column>
			</missingDensity>
			<missingDensity>
				<column>id</column>
				<column>type</column>
			</missingDensity>
			<missingDensity>
				<column>uid</column>
				<column>gid</column>
				<column>id</column>
			</missingDensity>
			<missingDensity>
				<column>uid</column>
				<column>gid</column>
				<column>id</column>
				<column>type</column>
			</missingDensity>
		</statInfo>
	</optimizerStatistics>
	<opTree>
		<lavaContext/>
		<Emit>
		<VA>4</VA>
		<est>
			<rowCnt>1</rowCnt>
			<lio>0</lio>
			<pio>0</pio>
			<rowSz>273.3559</rowSz>
		</est>
		<act>
			<rowCnt>0</rowCnt>
		</act>
		<arity>1</arity>
			<Restrict>
			<VA>3</VA>
			<est>
				<rowCnt>1</rowCnt>
				<lio>0</lio>
				<pio>0</pio>
				<rowSz>273.3559</rowSz>
			</est>
			<act>
				<rowCnt>0</rowCnt>
			</act>
			<arity>1</arity>
				<NestLoopJoin>
				<VA>2</VA>
				<est>
					<rowCnt>1</rowCnt>
					<lio>0</lio>
					<pio>0</pio>
					<rowSz>273.3559</rowSz>
				</est>
				<act>
					<rowCnt>0</rowCnt>
				</act>
				<arity>2</arity>
					<IndexScan>
						<VA>0</VA>
						<est>
							<rowCnt>1</rowCnt>
							<lio>3</lio>
							<pio>2.999999</pio>
							<rowSz>148.178</rowSz>
						</est>
						<act>
							<rowCnt>0</rowCnt>
							<lio>1</lio>
							<pio>0</pio>
						</act>
						<varNo>0</varNo>
						<objName>sysqueryplans</objName>
						<corrName>a</corrName>
						<scanType>IndexScan</scanType>
						<indName>ncsysqueryplans</indName>
						<indId>3</indId>
						<scanOrder> ForwardScan </scanOrder>
						<positioning> StartOfIndex </positioning>
						<indexIOSizeInKB>4</indexIOSizeInKB>
						<indexBufReplStrategy> LRU </indexBufReplStrategy>
						<dataIOSizeInKB>4</dataIOSizeInKB>
						<dataBufReplStrategy> LRU </dataBufReplStrategy>
					</IndexScan>
					<IndexScan>
						<VA>1</VA>
						<est>
							<rowCnt>1</rowCnt>
							<lio>3</lio>
							<pio>2.999999</pio>
							<rowSz>142.178</rowSz>
						</est>
						<act>
							<rowCnt>0</rowCnt>
							<lio>0</lio>
							<pio>0</pio>
						</act>
						<varNo>1</varNo>
						<objName>sysqueryplans</objName>
						<corrName>b</corrName>
						<scanType>IndexScan</scanType>
						<indName>csysqueryplans</indName>
						<indId>2</indId>
						<scanOrder> ForwardScan </scanOrder>
						<positioning> ByKey </positioning>
						<perKey>
							<keyCol>uid</keyCol>
							<keyOrder> Ascending </keyOrder>
						</perKey>
						<perKey>
							<keyCol>gid</keyCol>
							<keyOrder> Ascending </keyOrder>
						</perKey>
						<indexIOSizeInKB>4</indexIOSizeInKB>
						<indexBufReplStrategy> LRU </indexBufReplStrategy>
						<dataIOSizeInKB>4</dataIOSizeInKB>
						<dataBufReplStrategy> LRU </dataBufReplStrategy>
					</IndexScan>
				</NestLoopJoin>
			</Restrict>
		</Emit>
	</opTree>
</query>