NOTIN_Planner_Benchmark.htm
text/html
Filename: NOTIN_Planner_Benchmark.htm
Type: text/html
Part: 1
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 15">
<link rel=File-List href="NOTIN_Planner_Benchmark_files/filelist.xml">
<style id="NOTIN_Planner_Benchmark_20689_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl1520689
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6320689
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:Percent;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6420689
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:Percent;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
-->
</style>
</head>
<body>
<!--[if !excel]> <![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
<div id="NOTIN_Planner_Benchmark_20689" align=center x:publishsource="Excel">
<table border=0 cellpadding=0 cellspacing=0 width=961 style='border-collapse:
collapse;table-layout:fixed;width:722pt'>
<col width=64 style='width:48pt'>
<col width=69 style='mso-width-source:userset;mso-width-alt:2523;width:52pt'>
<col width=165 style='mso-width-source:userset;mso-width-alt:6034;width:124pt'>
<col width=217 style='mso-width-source:userset;mso-width-alt:7936;width:163pt'>
<col width=168 style='mso-width-source:userset;mso-width-alt:6144;width:126pt'>
<col width=278 style='mso-width-source:userset;mso-width-alt:10166;width:209pt'>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 width=64 style='height:15.0pt;width:48pt'></td>
<td class=xl1520689 width=69 style='width:52pt'>Loops</td>
<td class=xl1520689 align=right width=165 style='width:124pt'>100000</td>
<td class=xl1520689 width=217 style='width:163pt'></td>
<td class=xl1520689 width=168 style='width:126pt'></td>
<td class=xl1520689 width=278 style='width:209pt'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'></td>
<td class=xl1520689></td>
<td class=xl1520689>Total planning time. (ms)</td>
<td class=xl1520689>Est time for not in pre-check (ms)</td>
<td class=xl1520689>Plan time with patch (ms)</td>
<td class=xl1520689>est % of plantime spent checking for NULLs</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 1</td>
<td class=xl1520689>Run 1</td>
<td class=xl1520689 align=right>130.387</td>
<td class=xl1520689 align=right>0.00130387</td>
<td class=xl1520689 align=right>0.223</td>
<td class=xl6320689 align=right>0.58%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 1</td>
<td class=xl1520689>Run 2</td>
<td class=xl1520689 align=right>128.333</td>
<td class=xl1520689 align=right>0.00128333</td>
<td class=xl1520689 align=right>0.228</td>
<td class=xl6320689 align=right>0.56%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 1</td>
<td class=xl1520689>Run 3</td>
<td class=xl1520689 align=right>128.114</td>
<td class=xl1520689 align=right>0.00128114</td>
<td class=xl1520689 align=right>0.224</td>
<td class=xl6320689 align=right>0.57%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 2</td>
<td class=xl1520689>Run 1</td>
<td class=xl1520689 align=right>150.803</td>
<td class=xl1520689 align=right>0.00150803</td>
<td class=xl1520689 align=right>0.232</td>
<td class=xl6320689 align=right>0.65%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 2</td>
<td class=xl1520689>Run 2</td>
<td class=xl1520689 align=right>150.869</td>
<td class=xl1520689 align=right>0.00150869</td>
<td class=xl1520689 align=right>0.278</td>
<td class=xl6320689 align=right>0.54%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 2</td>
<td class=xl1520689>Run 3</td>
<td class=xl1520689 align=right>148.839</td>
<td class=xl1520689 align=right>0.00148839</td>
<td class=xl1520689 align=right>0.223</td>
<td class=xl6320689 align=right>0.67%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 3</td>
<td class=xl1520689>Run 1</td>
<td class=xl1520689 align=right>122.829</td>
<td class=xl1520689 align=right>0.00122829</td>
<td class=xl1520689 align=right>0.291</td>
<td class=xl6320689 align=right>0.42%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 3</td>
<td class=xl1520689>Run 2</td>
<td class=xl1520689 align=right>122.365</td>
<td class=xl1520689 align=right>0.00122365</td>
<td class=xl1520689 align=right>0.259</td>
<td class=xl6320689 align=right>0.47%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 3</td>
<td class=xl1520689>Run 3</td>
<td class=xl1520689 align=right>121.541</td>
<td class=xl1520689 align=right>0.00121541</td>
<td class=xl1520689 align=right>0.249</td>
<td class=xl6320689 align=right>0.49%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 4</td>
<td class=xl1520689>Run 1</td>
<td class=xl1520689 align=right>297.944</td>
<td class=xl1520689 align=right>0.00297944</td>
<td class=xl1520689 align=right>0.429</td>
<td class=xl6320689 align=right>0.69%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 4</td>
<td class=xl1520689>Run 2</td>
<td class=xl1520689 align=right>322.461</td>
<td class=xl1520689 align=right>0.00322461</td>
<td class=xl1520689 align=right>0.394</td>
<td class=xl6320689 align=right>0.82%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 4</td>
<td class=xl1520689>Run 3</td>
<td class=xl1520689 align=right>417.939</td>
<td class=xl1520689 align=right>0.00417939</td>
<td class=xl1520689 align=right>0.489</td>
<td class=xl6320689 align=right>0.85%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 5</td>
<td class=xl1520689>Run 1</td>
<td class=xl1520689 align=right>648.032</td>
<td class=xl1520689 align=right>0.00648032</td>
<td class=xl1520689 align=right>0.313</td>
<td class=xl6320689 align=right>2.07%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 5</td>
<td class=xl1520689>Run 2</td>
<td class=xl1520689 align=right>592.196</td>
<td class=xl1520689 align=right>0.00592196</td>
<td class=xl1520689 align=right>0.284</td>
<td class=xl6320689 align=right>2.09%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 5</td>
<td class=xl1520689>Run 3</td>
<td class=xl1520689 align=right>642.122</td>
<td class=xl1520689 align=right>0.00642122</td>
<td class=xl1520689 align=right>0.278</td>
<td class=xl6320689 align=right>2.31%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 6</td>
<td class=xl1520689>Run 1</td>
<td class=xl1520689 align=right>39.08</td>
<td class=xl1520689 align=right>0.0003908</td>
<td class=xl1520689 align=right>0.221</td>
<td class=xl6320689 align=right>0.18%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 6</td>
<td class=xl1520689>Run 2</td>
<td class=xl1520689 align=right>40.992</td>
<td class=xl1520689 align=right>0.00040992</td>
<td class=xl1520689 align=right>0.212</td>
<td class=xl6320689 align=right>0.19%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'>Query 6</td>
<td class=xl1520689>Run 3</td>
<td class=xl1520689 align=right>38.585</td>
<td class=xl1520689 align=right>0.00038585</td>
<td class=xl1520689 align=right>0.281</td>
<td class=xl6320689 align=right>0.14%</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1520689 style='height:15.0pt'></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
<td class=xl1520689></td>
<td class=xl6420689></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=64 style='width:48pt'></td>
<td width=69 style='width:52pt'></td>
<td width=165 style='width:124pt'></td>
<td width=217 style='width:163pt'></td>
<td width=168 style='width:126pt'></td>
<td width=278 style='width:209pt'></td>
</tr>
<![endif]>
</table>
</div>
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
</html>