| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
| <head> |
| <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> |
| <title>QueryPlanModel xref</title> |
| <link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" /> |
| </head> |
| <body> |
| <div id="overview"><a href="../../../../../apidocs/org/trafodion/dcs/master/QueryPlanModel.html">View Javadoc</a></div><pre> |
| |
| <a class="jxr_linenumber" name="1" href="#1">1</a> <em class="jxr_javadoccomment">/**</em> |
| <a class="jxr_linenumber" name="2" href="#2">2</a> <em class="jxr_javadoccomment">* @@@ START COPYRIGHT @@@</em> |
| <a class="jxr_linenumber" name="3" href="#3">3</a> <em class="jxr_javadoccomment">*</em> |
| <a class="jxr_linenumber" name="4" href="#4">4</a> <em class="jxr_javadoccomment">* Licensed to the Apache Software Foundation (ASF) under one</em> |
| <a class="jxr_linenumber" name="5" href="#5">5</a> <em class="jxr_javadoccomment">* or more contributor license agreements. See the NOTICE file</em> |
| <a class="jxr_linenumber" name="6" href="#6">6</a> <em class="jxr_javadoccomment">* distributed with this work for additional information</em> |
| <a class="jxr_linenumber" name="7" href="#7">7</a> <em class="jxr_javadoccomment">* regarding copyright ownership. The ASF licenses this file</em> |
| <a class="jxr_linenumber" name="8" href="#8">8</a> <em class="jxr_javadoccomment">* to you under the Apache License, Version 2.0 (the</em> |
| <a class="jxr_linenumber" name="9" href="#9">9</a> <em class="jxr_javadoccomment">* "License"); you may not use this file except in compliance</em> |
| <a class="jxr_linenumber" name="10" href="#10">10</a> <em class="jxr_javadoccomment">* with the License. You may obtain a copy of the License at</em> |
| <a class="jxr_linenumber" name="11" href="#11">11</a> <em class="jxr_javadoccomment">*</em> |
| <a class="jxr_linenumber" name="12" href="#12">12</a> <em class="jxr_javadoccomment">* <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em> |
| <a class="jxr_linenumber" name="13" href="#13">13</a> <em class="jxr_javadoccomment">*</em> |
| <a class="jxr_linenumber" name="14" href="#14">14</a> <em class="jxr_javadoccomment">* Unless required by applicable law or agreed to in writing,</em> |
| <a class="jxr_linenumber" name="15" href="#15">15</a> <em class="jxr_javadoccomment">* software distributed under the License is distributed on an</em> |
| <a class="jxr_linenumber" name="16" href="#16">16</a> <em class="jxr_javadoccomment">* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</em> |
| <a class="jxr_linenumber" name="17" href="#17">17</a> <em class="jxr_javadoccomment">* KIND, either express or implied. See the License for the</em> |
| <a class="jxr_linenumber" name="18" href="#18">18</a> <em class="jxr_javadoccomment">* specific language governing permissions and limitations</em> |
| <a class="jxr_linenumber" name="19" href="#19">19</a> <em class="jxr_javadoccomment">* under the License.</em> |
| <a class="jxr_linenumber" name="20" href="#20">20</a> <em class="jxr_javadoccomment">*</em> |
| <a class="jxr_linenumber" name="21" href="#21">21</a> <em class="jxr_javadoccomment">* @@@ END COPYRIGHT @@@</em> |
| <a class="jxr_linenumber" name="22" href="#22">22</a> <em class="jxr_javadoccomment">**/</em> |
| <a class="jxr_linenumber" name="23" href="#23">23</a> |
| <a class="jxr_linenumber" name="24" href="#24">24</a> <strong class="jxr_keyword">package</strong> org.trafodion.dcs.master; |
| <a class="jxr_linenumber" name="25" href="#25">25</a> |
| <a class="jxr_linenumber" name="26" href="#26">26</a> <strong class="jxr_keyword">import</strong> java.sql.ResultSet; |
| <a class="jxr_linenumber" name="27" href="#27">27</a> <strong class="jxr_keyword">import</strong> java.sql.SQLException; |
| <a class="jxr_linenumber" name="28" href="#28">28</a> <strong class="jxr_keyword">import</strong> java.sql.Statement; |
| <a class="jxr_linenumber" name="29" href="#29">29</a> <strong class="jxr_keyword">import</strong> java.util.ArrayList; |
| <a class="jxr_linenumber" name="30" href="#30">30</a> <strong class="jxr_keyword">import</strong> java.util.Enumeration; |
| <a class="jxr_linenumber" name="31" href="#31">31</a> <strong class="jxr_keyword">import</strong> java.util.Hashtable; |
| <a class="jxr_linenumber" name="32" href="#32">32</a> <strong class="jxr_keyword">import</strong> java.util.regex.Matcher; |
| <a class="jxr_linenumber" name="33" href="#33">33</a> <strong class="jxr_keyword">import</strong> java.util.regex.Pattern; |
| <a class="jxr_linenumber" name="34" href="#34">34</a> |
| <a class="jxr_linenumber" name="35" href="#35">35</a> <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log; |
| <a class="jxr_linenumber" name="36" href="#36">36</a> <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory; |
| <a class="jxr_linenumber" name="37" href="#37">37</a> |
| <a class="jxr_linenumber" name="38" href="#38">38</a> <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.TrafT4Connection; |
| <a class="jxr_linenumber" name="39" href="#39">39</a> <strong class="jxr_keyword">import</strong> org.trafodion.jdbc.t4.TrafT4PreparedStatement; |
| <a class="jxr_linenumber" name="40" href="#40">40</a> <strong class="jxr_keyword">import</strong> org.trafodion.dcs.util.JdbcT4Util; |
| <a class="jxr_linenumber" name="41" href="#41">41</a> |
| <a class="jxr_linenumber" name="42" href="#42">42</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanModel</a> { |
| <a class="jxr_linenumber" name="43" href="#43">43</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Log LOG = LogFactory.getLog(QueryPlanModel.<strong class="jxr_keyword">class</strong>); |
| <a class="jxr_linenumber" name="44" href="#44">44</a> <strong class="jxr_keyword">public</strong> ArrayList<QueryPlanData> QueryPlanArray = <strong class="jxr_keyword">new</strong> ArrayList<QueryPlanData>(); |
| <a class="jxr_linenumber" name="45" href="#45">45</a> <strong class="jxr_keyword">public</strong> Hashtable planStepsHT = <strong class="jxr_keyword">new</strong> Hashtable (); |
| <a class="jxr_linenumber" name="46" href="#46">46</a> <strong class="jxr_keyword">private</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> queryPlanData; |
| <a class="jxr_linenumber" name="47" href="#47">47</a> <strong class="jxr_keyword">private</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> rootPlan; |
| <a class="jxr_linenumber" name="48" href="#48">48</a> <strong class="jxr_keyword">private</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">PlanSummaryInfo</a> planSummaryInfo = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="49" href="#49">49</a> |
| <a class="jxr_linenumber" name="50" href="#50">50</a> <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> getQueryPlanData() { |
| <a class="jxr_linenumber" name="51" href="#51">51</a> <strong class="jxr_keyword">return</strong> queryPlanData; |
| <a class="jxr_linenumber" name="52" href="#52">52</a> } |
| <a class="jxr_linenumber" name="53" href="#53">53</a> |
| <a class="jxr_linenumber" name="54" href="#54">54</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setQueryPlanData(<a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> _queryPlanData) { |
| <a class="jxr_linenumber" name="55" href="#55">55</a> <strong class="jxr_keyword">this</strong>.queryPlanData = _queryPlanData; |
| <a class="jxr_linenumber" name="56" href="#56">56</a> } |
| <a class="jxr_linenumber" name="57" href="#57">57</a> |
| <a class="jxr_linenumber" name="58" href="#58">58</a> <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> getRootPlan() { |
| <a class="jxr_linenumber" name="59" href="#59">59</a> <strong class="jxr_keyword">return</strong> rootPlan; |
| <a class="jxr_linenumber" name="60" href="#60">60</a> } |
| <a class="jxr_linenumber" name="61" href="#61">61</a> |
| <a class="jxr_linenumber" name="62" href="#62">62</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setRootPlan(<a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> _rootPlan) { |
| <a class="jxr_linenumber" name="63" href="#63">63</a> <strong class="jxr_keyword">this</strong>.rootPlan = _rootPlan; |
| <a class="jxr_linenumber" name="64" href="#64">64</a> } |
| <a class="jxr_linenumber" name="65" href="#65">65</a> |
| <a class="jxr_linenumber" name="66" href="#66">66</a> <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">PlanSummaryInfo</a> getPlanSummaryInfo() { |
| <a class="jxr_linenumber" name="67" href="#67">67</a> <strong class="jxr_keyword">return</strong> planSummaryInfo; |
| <a class="jxr_linenumber" name="68" href="#68">68</a> } |
| <a class="jxr_linenumber" name="69" href="#69">69</a> |
| <a class="jxr_linenumber" name="70" href="#70">70</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setPlanSummaryInfo(<a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">PlanSummaryInfo</a> _planSummaryInfo) { |
| <a class="jxr_linenumber" name="71" href="#71">71</a> <strong class="jxr_keyword">this</strong>.planSummaryInfo = _planSummaryInfo; |
| <a class="jxr_linenumber" name="72" href="#72">72</a> } |
| <a class="jxr_linenumber" name="73" href="#73">73</a> |
| <a class="jxr_linenumber" name="74" href="#74">74</a> <strong class="jxr_keyword">public</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanResponse.html">QueryPlanResponse</a> getQueryPlanResponse() { |
| <a class="jxr_linenumber" name="75" href="#75">75</a> <strong class="jxr_keyword">return</strong> getQueryPlanResponse(<strong class="jxr_keyword">null</strong>, -1,<span class="jxr_string">"L"</span>,<strong class="jxr_keyword">null</strong>); |
| <a class="jxr_linenumber" name="76" href="#76">76</a> } |
| <a class="jxr_linenumber" name="77" href="#77">77</a> |
| <a class="jxr_linenumber" name="78" href="#78">78</a> <strong class="jxr_keyword">private</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanResponse.html">QueryPlanResponse</a> getQueryPlanResponse(<a href="../../../../org/trafodion/dcs/master/QueryPlanResponse.html">QueryPlanResponse</a> currentNode, <strong class="jxr_keyword">int</strong> seqNum, String position, String parentId) { |
| <a class="jxr_linenumber" name="79" href="#79">79</a> <strong class="jxr_keyword">if</strong>(currentNode == <strong class="jxr_keyword">null</strong>) { |
| <a class="jxr_linenumber" name="80" href="#80">80</a> currentNode = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanResponse.html">QueryPlanResponse</a>(); |
| <a class="jxr_linenumber" name="81" href="#81">81</a> <strong class="jxr_keyword">int</strong> maxSeqNum = -1; |
| <a class="jxr_linenumber" name="82" href="#82">82</a> <strong class="jxr_keyword">for</strong>(Object key : planStepsHT.keySet()) { |
| <a class="jxr_linenumber" name="83" href="#83">83</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="84" href="#84">84</a> <strong class="jxr_keyword">int</strong> intKey = Integer.parseInt(key.toString()); |
| <a class="jxr_linenumber" name="85" href="#85">85</a> <strong class="jxr_keyword">if</strong>(maxSeqNum < intKey) { |
| <a class="jxr_linenumber" name="86" href="#86">86</a> maxSeqNum = intKey; |
| <a class="jxr_linenumber" name="87" href="#87">87</a> } |
| <a class="jxr_linenumber" name="88" href="#88">88</a> }<strong class="jxr_keyword">catch</strong>(Exception e) {} |
| <a class="jxr_linenumber" name="89" href="#89">89</a> } |
| <a class="jxr_linenumber" name="90" href="#90">90</a> seqNum = maxSeqNum; |
| <a class="jxr_linenumber" name="91" href="#91">91</a> } |
| <a class="jxr_linenumber" name="92" href="#92">92</a> |
| <a class="jxr_linenumber" name="93" href="#93">93</a> QueryPlanData qdp = (QueryPlanData)planStepsHT.get(seqNum); |
| <a class="jxr_linenumber" name="94" href="#94">94</a> currentNode.id = parentId!=<strong class="jxr_keyword">null</strong> ? parentId + position : qdp.sequenceNumber; |
| <a class="jxr_linenumber" name="95" href="#95">95</a> currentNode.name = qdp.theOperator; |
| <a class="jxr_linenumber" name="96" href="#96">96</a> currentNode.data.put(<span class="jxr_string">"formattedCostDesc"</span>, qdp.formattedCostDesc); |
| <a class="jxr_linenumber" name="97" href="#97">97</a> |
| <a class="jxr_linenumber" name="98" href="#98">98</a> <strong class="jxr_keyword">if</strong>(qdp.leftChildSeqNum != <strong class="jxr_keyword">null</strong>) { |
| <a class="jxr_linenumber" name="99" href="#99">99</a> <strong class="jxr_keyword">int</strong> leftSeqNum = getIntValue(qdp.leftChildSeqNum); |
| <a class="jxr_linenumber" name="100" href="#100">100</a> <strong class="jxr_keyword">if</strong>(leftSeqNum > -1) { |
| <a class="jxr_linenumber" name="101" href="#101">101</a> QueryPlanResponse leftNode = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanResponse.html">QueryPlanResponse</a>(); |
| <a class="jxr_linenumber" name="102" href="#102">102</a> getQueryPlanResponse(leftNode, leftSeqNum, <span class="jxr_string">"L"</span>, currentNode.id); |
| <a class="jxr_linenumber" name="103" href="#103">103</a> currentNode.getChildren().add(leftNode); |
| <a class="jxr_linenumber" name="104" href="#104">104</a> } |
| <a class="jxr_linenumber" name="105" href="#105">105</a> } |
| <a class="jxr_linenumber" name="106" href="#106">106</a> <strong class="jxr_keyword">if</strong>(qdp.rightChildSeqNum != <strong class="jxr_keyword">null</strong>) { |
| <a class="jxr_linenumber" name="107" href="#107">107</a> <strong class="jxr_keyword">int</strong> rightSeqNum = getIntValue(qdp.rightChildSeqNum); |
| <a class="jxr_linenumber" name="108" href="#108">108</a> <strong class="jxr_keyword">if</strong>(rightSeqNum > -1) { |
| <a class="jxr_linenumber" name="109" href="#109">109</a> QueryPlanResponse rightNode = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanResponse.html">QueryPlanResponse</a>(); |
| <a class="jxr_linenumber" name="110" href="#110">110</a> getQueryPlanResponse(rightNode, rightSeqNum,<span class="jxr_string">"R"</span>, currentNode.id); |
| <a class="jxr_linenumber" name="111" href="#111">111</a> currentNode.getChildren().add(rightNode); |
| <a class="jxr_linenumber" name="112" href="#112">112</a> } |
| <a class="jxr_linenumber" name="113" href="#113">113</a> } |
| <a class="jxr_linenumber" name="114" href="#114">114</a> |
| <a class="jxr_linenumber" name="115" href="#115">115</a> <strong class="jxr_keyword">return</strong> currentNode; |
| <a class="jxr_linenumber" name="116" href="#116">116</a> } |
| <a class="jxr_linenumber" name="117" href="#117">117</a> |
| <a class="jxr_linenumber" name="118" href="#118">118</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> GeneratePlan(<a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a> jdbcT4Util, String queryText, String controlStmts) <strong class="jxr_keyword">throws</strong> Exception { |
| <a class="jxr_linenumber" name="119" href="#119">119</a> <strong class="jxr_keyword">if</strong>(LOG.isDebugEnabled()) |
| <a class="jxr_linenumber" name="120" href="#120">120</a> LOG.debug(<span class="jxr_string">"queryText="</span>+ queryText + <span class="jxr_string">",controlStmts="</span> + controlStmts); |
| <a class="jxr_linenumber" name="121" href="#121">121</a> ArrayList<QueryPlanData> planDataArray = GetPlan(jdbcT4Util, queryText, controlStmts); |
| <a class="jxr_linenumber" name="122" href="#122">122</a> QueryPlanArray.clear(); |
| <a class="jxr_linenumber" name="123" href="#123">123</a> <strong class="jxr_keyword">for</strong> (QueryPlanData planData : planDataArray) { |
| <a class="jxr_linenumber" name="124" href="#124">124</a> setQueryPlanData(planData); |
| <a class="jxr_linenumber" name="125" href="#125">125</a> QueryPlanArray.add(planData); |
| <a class="jxr_linenumber" name="126" href="#126">126</a> } |
| <a class="jxr_linenumber" name="127" href="#127">127</a> SavePlanSteps(planDataArray); |
| <a class="jxr_linenumber" name="128" href="#128">128</a> CreateSummary(planDataArray); |
| <a class="jxr_linenumber" name="129" href="#129">129</a> } |
| <a class="jxr_linenumber" name="130" href="#130">130</a> |
| <a class="jxr_linenumber" name="131" href="#131">131</a> <strong class="jxr_keyword">public</strong> ArrayList<QueryPlanData> GetPlan(<a href="../../../../org/trafodion/dcs/util/JdbcT4Util.html">JdbcT4Util</a> jdbcT4Util, String queryText, String controlStmts) <strong class="jxr_keyword">throws</strong> Exception { |
| <a class="jxr_linenumber" name="132" href="#132">132</a> |
| <a class="jxr_linenumber" name="133" href="#133">133</a> ArrayList<QueryPlanData> planArray = <strong class="jxr_keyword">new</strong> ArrayList<QueryPlanData>(); |
| <a class="jxr_linenumber" name="134" href="#134">134</a> TrafT4Connection connection = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="135" href="#135">135</a> java.sql.Statement stmt = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="136" href="#136">136</a> TrafT4PreparedStatement pStmt = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="137" href="#137">137</a> java.sql.ResultSet rs; |
| <a class="jxr_linenumber" name="138" href="#138">138</a> String[] controlStatements = <strong class="jxr_keyword">new</strong> String[0]; |
| <a class="jxr_linenumber" name="139" href="#139">139</a> |
| <a class="jxr_linenumber" name="140" href="#140">140</a> <strong class="jxr_keyword">if</strong>(controlStmts != <strong class="jxr_keyword">null</strong> && controlStmts.length() > 0) { |
| <a class="jxr_linenumber" name="141" href="#141">141</a> controlStatements = controlStmts.split(<span class="jxr_string">";"</span>); |
| <a class="jxr_linenumber" name="142" href="#142">142</a> } |
| <a class="jxr_linenumber" name="143" href="#143">143</a> |
| <a class="jxr_linenumber" name="144" href="#144">144</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="145" href="#145">145</a> connection = (TrafT4Connection) jdbcT4Util.getConnection(); |
| <a class="jxr_linenumber" name="146" href="#146">146</a> stmt = connection.createStatement(); |
| <a class="jxr_linenumber" name="147" href="#147">147</a> <strong class="jxr_keyword">for</strong>(String controlText : controlStatements) { |
| <a class="jxr_linenumber" name="148" href="#148">148</a> stmt.execute(controlText); |
| <a class="jxr_linenumber" name="149" href="#149">149</a> stmt.execute(controlText); |
| <a class="jxr_linenumber" name="150" href="#150">150</a> } |
| <a class="jxr_linenumber" name="151" href="#151">151</a> |
| <a class="jxr_linenumber" name="152" href="#152">152</a> pStmt = (TrafT4PreparedStatement) connection.prepareStatement(queryText, <span class="jxr_string">"SQL_CURSOR_DEMO"</span>); |
| <a class="jxr_linenumber" name="153" href="#153">153</a> rs = stmt.executeQuery(<span class="jxr_string">"SELECT * FROM TABLE(explain(null, 'SQL_CURSOR_DEMO'))"</span>); |
| <a class="jxr_linenumber" name="154" href="#154">154</a> |
| <a class="jxr_linenumber" name="155" href="#155">155</a> <strong class="jxr_keyword">while</strong> (rs.next()) { |
| <a class="jxr_linenumber" name="156" href="#156">156</a> QueryPlanData qpd = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a>(); |
| <a class="jxr_linenumber" name="157" href="#157">157</a> qpd.sequenceNumber = rs.getString(4); |
| <a class="jxr_linenumber" name="158" href="#158">158</a> qpd.theOperator = rs.getString(5).trim(); |
| <a class="jxr_linenumber" name="159" href="#159">159</a> qpd.leftChildSeqNum = rs.getString(6); |
| <a class="jxr_linenumber" name="160" href="#160">160</a> qpd.rightChildSeqNum = rs.getString(7); |
| <a class="jxr_linenumber" name="161" href="#161">161</a> qpd.tableName = rs.getString(8); |
| <a class="jxr_linenumber" name="162" href="#162">162</a> qpd.cardinality = rs.getString(9); |
| <a class="jxr_linenumber" name="163" href="#163">163</a> qpd.operatorCost = rs.getString(10); |
| <a class="jxr_linenumber" name="164" href="#164">164</a> qpd.totalCost = rs.getString(11); |
| <a class="jxr_linenumber" name="165" href="#165">165</a> qpd.detailCost = rs.getString(12); |
| <a class="jxr_linenumber" name="166" href="#166">166</a> qpd.description = rs.getString(13); |
| <a class="jxr_linenumber" name="167" href="#167">167</a> |
| <a class="jxr_linenumber" name="168" href="#168">168</a> String tableName = extractTableName(qpd.description); |
| <a class="jxr_linenumber" name="169" href="#169">169</a> <strong class="jxr_keyword">if</strong> (tableName != <strong class="jxr_keyword">null</strong> && tableName.length() > 0) { |
| <a class="jxr_linenumber" name="170" href="#170">170</a> qpd.tableName = GetExternalTableName(tableName); |
| <a class="jxr_linenumber" name="171" href="#171">171</a> } |
| <a class="jxr_linenumber" name="172" href="#172">172</a> qpd.formattedCostDesc = computeDisplayString(qpd.detailCost, qpd.description); |
| <a class="jxr_linenumber" name="173" href="#173">173</a> planArray.add(qpd); |
| <a class="jxr_linenumber" name="174" href="#174">174</a> } |
| <a class="jxr_linenumber" name="175" href="#175">175</a> rs.close(); |
| <a class="jxr_linenumber" name="176" href="#176">176</a> connection.close(); |
| <a class="jxr_linenumber" name="177" href="#177">177</a> } <strong class="jxr_keyword">catch</strong> (SQLException e) { |
| <a class="jxr_linenumber" name="178" href="#178">178</a> <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) |
| <a class="jxr_linenumber" name="179" href="#179">179</a> LOG.error(<span class="jxr_string">"Explain failed: "</span> + e.getMessage()); |
| <a class="jxr_linenumber" name="180" href="#180">180</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="181" href="#181">181</a> <strong class="jxr_keyword">if</strong> (stmt != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="182" href="#182">182</a> stmt.close(); |
| <a class="jxr_linenumber" name="183" href="#183">183</a> <strong class="jxr_keyword">if</strong> (connection != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="184" href="#184">184</a> connection.close(); |
| <a class="jxr_linenumber" name="185" href="#185">185</a> } <strong class="jxr_keyword">catch</strong> (SQLException sqle) {} |
| <a class="jxr_linenumber" name="186" href="#186">186</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> Exception(e.getMessage()); |
| <a class="jxr_linenumber" name="187" href="#187">187</a> } <strong class="jxr_keyword">catch</strong> (Exception e) { |
| <a class="jxr_linenumber" name="188" href="#188">188</a> <strong class="jxr_keyword">if</strong>(LOG.isErrorEnabled()) |
| <a class="jxr_linenumber" name="189" href="#189">189</a> LOG.error(<span class="jxr_string">"Explain failed: "</span> + e.getMessage()); |
| <a class="jxr_linenumber" name="190" href="#190">190</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="191" href="#191">191</a> <strong class="jxr_keyword">if</strong> (stmt != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="192" href="#192">192</a> stmt.close(); |
| <a class="jxr_linenumber" name="193" href="#193">193</a> <strong class="jxr_keyword">if</strong> (connection != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="194" href="#194">194</a> connection.close(); |
| <a class="jxr_linenumber" name="195" href="#195">195</a> } <strong class="jxr_keyword">catch</strong> (SQLException sqle) {} |
| <a class="jxr_linenumber" name="196" href="#196">196</a> <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> Exception(e.getMessage()); |
| <a class="jxr_linenumber" name="197" href="#197">197</a> } <strong class="jxr_keyword">finally</strong> { |
| <a class="jxr_linenumber" name="198" href="#198">198</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="199" href="#199">199</a> <strong class="jxr_keyword">if</strong> (stmt != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="200" href="#200">200</a> stmt.close(); |
| <a class="jxr_linenumber" name="201" href="#201">201</a> <strong class="jxr_keyword">if</strong> (connection != <strong class="jxr_keyword">null</strong>) |
| <a class="jxr_linenumber" name="202" href="#202">202</a> connection.close(); |
| <a class="jxr_linenumber" name="203" href="#203">203</a> } <strong class="jxr_keyword">catch</strong> (SQLException e) {} |
| <a class="jxr_linenumber" name="204" href="#204">204</a> } |
| <a class="jxr_linenumber" name="205" href="#205">205</a> |
| <a class="jxr_linenumber" name="206" href="#206">206</a> <strong class="jxr_keyword">return</strong> planArray; |
| <a class="jxr_linenumber" name="207" href="#207">207</a> } |
| <a class="jxr_linenumber" name="208" href="#208">208</a> |
| <a class="jxr_linenumber" name="209" href="#209">209</a> <strong class="jxr_keyword">public</strong> String computeDisplayString(String detailCost, String description) { |
| <a class="jxr_linenumber" name="210" href="#210">210</a> StringBuffer sb = <strong class="jxr_keyword">new</strong> StringBuffer(); |
| <a class="jxr_linenumber" name="211" href="#211">211</a> <strong class="jxr_keyword">try</strong> |
| <a class="jxr_linenumber" name="212" href="#212">212</a> { |
| <a class="jxr_linenumber" name="213" href="#213">213</a> Pattern pattern = Pattern.compile(<span class="jxr_string">"\\b(\\w+\\s*:=?\\s*[0-9\\.eE\\-\\+]*)"</span>); |
| <a class="jxr_linenumber" name="214" href="#214">214</a> Matcher matcher = pattern.matcher(detailCost); |
| <a class="jxr_linenumber" name="215" href="#215">215</a> |
| <a class="jxr_linenumber" name="216" href="#216">216</a> sb.append(<span class="jxr_string">" Costs:"</span> + <span class="jxr_string">"\n"</span>); |
| <a class="jxr_linenumber" name="217" href="#217">217</a> |
| <a class="jxr_linenumber" name="218" href="#218">218</a> ArrayList<String> nvPairs = <strong class="jxr_keyword">new</strong> ArrayList<String>(); |
| <a class="jxr_linenumber" name="219" href="#219">219</a> <strong class="jxr_keyword">while</strong>(matcher.find()) { |
| <a class="jxr_linenumber" name="220" href="#220">220</a> nvPairs.add(matcher.group()); |
| <a class="jxr_linenumber" name="221" href="#221">221</a> } |
| <a class="jxr_linenumber" name="222" href="#222">222</a> |
| <a class="jxr_linenumber" name="223" href="#223">223</a> <strong class="jxr_keyword">for</strong>(String s : nvPairs) |
| <a class="jxr_linenumber" name="224" href="#224">224</a> { |
| <a class="jxr_linenumber" name="225" href="#225">225</a> <strong class="jxr_keyword">if</strong> (0 < s.trim().length()) |
| <a class="jxr_linenumber" name="226" href="#226">226</a> { |
| <a class="jxr_linenumber" name="227" href="#227">227</a> <em class="jxr_comment">// In R2.4 Explain adds a := to the DETAIL_COST information -- go figure why!! :^(</em> |
| <a class="jxr_linenumber" name="228" href="#228">228</a> <em class="jxr_comment">// So we just replace it with a single ":", so it looks like the R2.3 one!!</em> |
| <a class="jxr_linenumber" name="229" href="#229">229</a> String costMetricAndValue = s.replace(<span class="jxr_string">":="</span>, <span class="jxr_string">":"</span>); |
| <a class="jxr_linenumber" name="230" href="#230">230</a> sb.append(<span class="jxr_string">" "</span> + costMetricAndValue + <span class="jxr_string">"\n"</span>); |
| <a class="jxr_linenumber" name="231" href="#231">231</a> |
| <a class="jxr_linenumber" name="232" href="#232">232</a> } |
| <a class="jxr_linenumber" name="233" href="#233">233</a> } |
| <a class="jxr_linenumber" name="234" href="#234">234</a> sb.append(<span class="jxr_string">"\n"</span>+ <span class="jxr_string">" Description:"</span> + <span class="jxr_string">"\n"</span>); |
| <a class="jxr_linenumber" name="235" href="#235">235</a> |
| <a class="jxr_linenumber" name="236" href="#236">236</a> |
| <a class="jxr_linenumber" name="237" href="#237">237</a> <em class="jxr_comment">//Pattern pattern2 = Pattern.compile("(\\b[A-Za-z0-9_\\(\\)]+\\s*:([^\\\\A-Z0-9a-z:]))");</em> |
| <a class="jxr_linenumber" name="238" href="#238">238</a> Pattern pattern2 = Pattern.compile(<span class="jxr_string">"(\\b[A-Za-z0-9_\\(\\)]+\\s*:).*?(?=\\b[^0-9\\-(NSK\\s*:)][A-Za-z0-9_\\(\\)]+\\s*:|$)"</span>); |
| <a class="jxr_linenumber" name="239" href="#239">239</a> Matcher matcher2 = pattern2.matcher(description); |
| <a class="jxr_linenumber" name="240" href="#240">240</a> nvPairs.clear(); |
| <a class="jxr_linenumber" name="241" href="#241">241</a> <strong class="jxr_keyword">while</strong>(matcher2.find()) { |
| <a class="jxr_linenumber" name="242" href="#242">242</a> nvPairs.add(matcher2.group()); |
| <a class="jxr_linenumber" name="243" href="#243">243</a> } |
| <a class="jxr_linenumber" name="244" href="#244">244</a> |
| <a class="jxr_linenumber" name="245" href="#245">245</a> <strong class="jxr_keyword">int</strong> idx = 0; |
| <a class="jxr_linenumber" name="246" href="#246">246</a> <strong class="jxr_keyword">while</strong> (nvPairs.size() > idx) |
| <a class="jxr_linenumber" name="247" href="#247">247</a> { |
| <a class="jxr_linenumber" name="248" href="#248">248</a> String nameStr = nvPairs.get(idx++).trim(); |
| <a class="jxr_linenumber" name="249" href="#249">249</a> |
| <a class="jxr_linenumber" name="250" href="#250">250</a> <strong class="jxr_keyword">if</strong> (0 >= nameStr.length()) |
| <a class="jxr_linenumber" name="251" href="#251">251</a> <strong class="jxr_keyword">continue</strong>; |
| <a class="jxr_linenumber" name="252" href="#252">252</a> |
| <a class="jxr_linenumber" name="253" href="#253">253</a> String valueStr = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="254" href="#254">254</a> <strong class="jxr_keyword">boolean</strong> found = false; |
| <a class="jxr_linenumber" name="255" href="#255">255</a> <strong class="jxr_keyword">boolean</strong> first_round = <strong class="jxr_keyword">true</strong>; |
| <a class="jxr_linenumber" name="256" href="#256">256</a> <strong class="jxr_keyword">while</strong> (!found && (nvPairs.size() > idx)) |
| <a class="jxr_linenumber" name="257" href="#257">257</a> { |
| <a class="jxr_linenumber" name="258" href="#258">258</a> <em class="jxr_comment">// Only assume one space between name and value pair. </em> |
| <a class="jxr_linenumber" name="259" href="#259">259</a> valueStr = nvPairs.get(idx).trim(); |
| <a class="jxr_linenumber" name="260" href="#260">260</a> <strong class="jxr_keyword">if</strong> (0 < valueStr.length() || !first_round) |
| <a class="jxr_linenumber" name="261" href="#261">261</a> { |
| <a class="jxr_linenumber" name="262" href="#262">262</a> found = <strong class="jxr_keyword">true</strong>; |
| <a class="jxr_linenumber" name="263" href="#263">263</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="264" href="#264">264</a> } |
| <a class="jxr_linenumber" name="265" href="#265">265</a> <strong class="jxr_keyword">else</strong> |
| <a class="jxr_linenumber" name="266" href="#266">266</a> { |
| <a class="jxr_linenumber" name="267" href="#267">267</a> first_round = false; |
| <a class="jxr_linenumber" name="268" href="#268">268</a> } |
| <a class="jxr_linenumber" name="269" href="#269">269</a> } |
| <a class="jxr_linenumber" name="270" href="#270">270</a> |
| <a class="jxr_linenumber" name="271" href="#271">271</a> sb.append(<span class="jxr_string">" "</span> + nameStr); |
| <a class="jxr_linenumber" name="272" href="#272">272</a> sb.append(<span class="jxr_string">" "</span> + valueStr + <span class="jxr_string">"\n"</span>); |
| <a class="jxr_linenumber" name="273" href="#273">273</a> } |
| <a class="jxr_linenumber" name="274" href="#274">274</a> }<strong class="jxr_keyword">catch</strong>(Exception ex) { |
| <a class="jxr_linenumber" name="275" href="#275">275</a> System.out.println(ex.getMessage()); |
| <a class="jxr_linenumber" name="276" href="#276">276</a> } |
| <a class="jxr_linenumber" name="277" href="#277">277</a> <strong class="jxr_keyword">return</strong> sb.toString(); |
| <a class="jxr_linenumber" name="278" href="#278">278</a> } |
| <a class="jxr_linenumber" name="279" href="#279">279</a> |
| <a class="jxr_linenumber" name="280" href="#280">280</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> String GetExternalTableName(String anAnsiName) { |
| <a class="jxr_linenumber" name="281" href="#281">281</a> anAnsiName = anAnsiName.trim(); |
| <a class="jxr_linenumber" name="282" href="#282">282</a> <strong class="jxr_keyword">if</strong> (anAnsiName == <strong class="jxr_keyword">null</strong> || anAnsiName.length() == 0) |
| <a class="jxr_linenumber" name="283" href="#283">283</a> <strong class="jxr_keyword">return</strong> <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="284" href="#284">284</a> |
| <a class="jxr_linenumber" name="285" href="#285">285</a> <strong class="jxr_keyword">boolean</strong> inQuotes = false; |
| <a class="jxr_linenumber" name="286" href="#286">286</a> <strong class="jxr_keyword">int</strong> theBeginOffset = 0; |
| <a class="jxr_linenumber" name="287" href="#287">287</a> |
| <a class="jxr_linenumber" name="288" href="#288">288</a> <strong class="jxr_keyword">int</strong> theResultPart = 0; |
| <a class="jxr_linenumber" name="289" href="#289">289</a> |
| <a class="jxr_linenumber" name="290" href="#290">290</a> <strong class="jxr_keyword">int</strong> theAnsiLength = anAnsiName.length(); |
| <a class="jxr_linenumber" name="291" href="#291">291</a> |
| <a class="jxr_linenumber" name="292" href="#292">292</a> String[] theResult = <strong class="jxr_keyword">new</strong> String[3]; |
| <a class="jxr_linenumber" name="293" href="#293">293</a> |
| <a class="jxr_linenumber" name="294" href="#294">294</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> theCurrentOffset = 0; theCurrentOffset < theAnsiLength; theCurrentOffset++) { |
| <a class="jxr_linenumber" name="295" href="#295">295</a> <strong class="jxr_keyword">char</strong> theCharacter = anAnsiName.charAt(theCurrentOffset); |
| <a class="jxr_linenumber" name="296" href="#296">296</a> |
| <a class="jxr_linenumber" name="297" href="#297">297</a> <strong class="jxr_keyword">switch</strong> (theCharacter) { |
| <a class="jxr_linenumber" name="298" href="#298">298</a> <strong class="jxr_keyword">case</strong> '"': { |
| <a class="jxr_linenumber" name="299" href="#299">299</a> inQuotes = !inQuotes; |
| <a class="jxr_linenumber" name="300" href="#300">300</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="301" href="#301">301</a> } |
| <a class="jxr_linenumber" name="302" href="#302">302</a> <strong class="jxr_keyword">case</strong> '.': { |
| <a class="jxr_linenumber" name="303" href="#303">303</a> <strong class="jxr_keyword">if</strong> (!inQuotes) { |
| <a class="jxr_linenumber" name="304" href="#304">304</a> theResult[theResultPart] = anAnsiName.substring(theBeginOffset, theCurrentOffset); |
| <a class="jxr_linenumber" name="305" href="#305">305</a> theResultPart++; |
| <a class="jxr_linenumber" name="306" href="#306">306</a> theBeginOffset = theCurrentOffset + 1; |
| <a class="jxr_linenumber" name="307" href="#307">307</a> } |
| <a class="jxr_linenumber" name="308" href="#308">308</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="309" href="#309">309</a> } |
| <a class="jxr_linenumber" name="310" href="#310">310</a> <strong class="jxr_keyword">default</strong>: { |
| <a class="jxr_linenumber" name="311" href="#311">311</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="312" href="#312">312</a> } |
| <a class="jxr_linenumber" name="313" href="#313">313</a> } |
| <a class="jxr_linenumber" name="314" href="#314">314</a> |
| <a class="jxr_linenumber" name="315" href="#315">315</a> } |
| <a class="jxr_linenumber" name="316" href="#316">316</a> theResult[theResultPart] = anAnsiName.substring(theBeginOffset); |
| <a class="jxr_linenumber" name="317" href="#317">317</a> String externalTableName = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="318" href="#318">318</a> |
| <a class="jxr_linenumber" name="319" href="#319">319</a> Pattern pattern = Pattern.compile(<span class="jxr_string">"^[A-Z0-9_]+$"</span>); |
| <a class="jxr_linenumber" name="320" href="#320">320</a> |
| <a class="jxr_linenumber" name="321" href="#321">321</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < theResult.length; i++) { |
| <a class="jxr_linenumber" name="322" href="#322">322</a> <strong class="jxr_keyword">if</strong> (theResult[i] == <strong class="jxr_keyword">null</strong> || theResult[i].length() == 0) |
| <a class="jxr_linenumber" name="323" href="#323">323</a> <strong class="jxr_keyword">continue</strong>; |
| <a class="jxr_linenumber" name="324" href="#324">324</a> |
| <a class="jxr_linenumber" name="325" href="#325">325</a> <strong class="jxr_keyword">if</strong> (i < theResult.length && !(externalTableName == <strong class="jxr_keyword">null</strong> || externalTableName.length() == 0)) { |
| <a class="jxr_linenumber" name="326" href="#326">326</a> externalTableName = externalTableName + <span class="jxr_string">"."</span>; |
| <a class="jxr_linenumber" name="327" href="#327">327</a> } |
| <a class="jxr_linenumber" name="328" href="#328">328</a> |
| <a class="jxr_linenumber" name="329" href="#329">329</a> Matcher matcher = pattern.matcher(externalTableName); |
| <a class="jxr_linenumber" name="330" href="#330">330</a> <strong class="jxr_keyword">if</strong> (matcher.find()) { |
| <a class="jxr_linenumber" name="331" href="#331">331</a> externalTableName = externalTableName + theResult[i]; |
| <a class="jxr_linenumber" name="332" href="#332">332</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="333" href="#333">333</a> <strong class="jxr_keyword">if</strong> (theResult[i].startsWith(<span class="jxr_string">"\""</span>) && theResult[i].endsWith(<span class="jxr_string">"\""</span>)) { |
| <a class="jxr_linenumber" name="334" href="#334">334</a> externalTableName = externalTableName + theResult[i]; |
| <a class="jxr_linenumber" name="335" href="#335">335</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="336" href="#336">336</a> theResult[i] = theResult[i].replace(<span class="jxr_string">"\""</span>, <span class="jxr_string">"\"\""</span>); |
| <a class="jxr_linenumber" name="337" href="#337">337</a> <em class="jxr_comment">// It has specials; delimit it.</em> |
| <a class="jxr_linenumber" name="338" href="#338">338</a> externalTableName = externalTableName + <span class="jxr_string">"\""</span> + theResult[i] + <span class="jxr_string">"\""</span>; |
| <a class="jxr_linenumber" name="339" href="#339">339</a> } |
| <a class="jxr_linenumber" name="340" href="#340">340</a> } |
| <a class="jxr_linenumber" name="341" href="#341">341</a> |
| <a class="jxr_linenumber" name="342" href="#342">342</a> } |
| <a class="jxr_linenumber" name="343" href="#343">343</a> <strong class="jxr_keyword">return</strong> externalTableName; |
| <a class="jxr_linenumber" name="344" href="#344">344</a> } |
| <a class="jxr_linenumber" name="345" href="#345">345</a> |
| <a class="jxr_linenumber" name="346" href="#346">346</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> String extractTableName(String description) { |
| <a class="jxr_linenumber" name="347" href="#347">347</a> String tableName = <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="348" href="#348">348</a> <strong class="jxr_keyword">int</strong> iud_type_pos = description.indexOf(<span class="jxr_string">"iud_type: "</span>); |
| <a class="jxr_linenumber" name="349" href="#349">349</a> <strong class="jxr_keyword">if</strong> (iud_type_pos > -1) { |
| <a class="jxr_linenumber" name="350" href="#350">350</a> <em class="jxr_comment">// format for the iud_type is</em> |
| <a class="jxr_linenumber" name="351" href="#351">351</a> <em class="jxr_comment">// iud_type: <operator> <table name></em> |
| <a class="jxr_linenumber" name="352" href="#352">352</a> tableName = description.substring(iud_type_pos + 10); |
| <a class="jxr_linenumber" name="353" href="#353">353</a> <strong class="jxr_keyword">int</strong> theBeginOffset = 0; |
| <a class="jxr_linenumber" name="354" href="#354">354</a> <strong class="jxr_keyword">int</strong> tokenIndex = 0; |
| <a class="jxr_linenumber" name="355" href="#355">355</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> theCurrentOffset = 0; theCurrentOffset < tableName.length(); theCurrentOffset++) { |
| <a class="jxr_linenumber" name="356" href="#356">356</a> <strong class="jxr_keyword">char</strong> theCharacter = tableName.charAt(theCurrentOffset); |
| <a class="jxr_linenumber" name="357" href="#357">357</a> |
| <a class="jxr_linenumber" name="358" href="#358">358</a> <strong class="jxr_keyword">switch</strong> (theCharacter) { |
| <a class="jxr_linenumber" name="359" href="#359">359</a> <strong class="jxr_keyword">case</strong> ' ': { |
| <a class="jxr_linenumber" name="360" href="#360">360</a> String currentToken = tableName.substring(theBeginOffset, theCurrentOffset); |
| <a class="jxr_linenumber" name="361" href="#361">361</a> theBeginOffset = theCurrentOffset + 1; |
| <a class="jxr_linenumber" name="362" href="#362">362</a> <strong class="jxr_keyword">if</strong> (tokenIndex == 1) { |
| <a class="jxr_linenumber" name="363" href="#363">363</a> tableName = currentToken; <em class="jxr_comment">// tablename is the the second</em> |
| <a class="jxr_linenumber" name="364" href="#364">364</a> <em class="jxr_comment">// token after the uid_type</em> |
| <a class="jxr_linenumber" name="365" href="#365">365</a> <em class="jxr_comment">// token.</em> |
| <a class="jxr_linenumber" name="366" href="#366">366</a> <strong class="jxr_keyword">return</strong> tableName; |
| <a class="jxr_linenumber" name="367" href="#367">367</a> } |
| <a class="jxr_linenumber" name="368" href="#368">368</a> tokenIndex++; |
| <a class="jxr_linenumber" name="369" href="#369">369</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="370" href="#370">370</a> } |
| <a class="jxr_linenumber" name="371" href="#371">371</a> <strong class="jxr_keyword">default</strong>: |
| <a class="jxr_linenumber" name="372" href="#372">372</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="373" href="#373">373</a> } |
| <a class="jxr_linenumber" name="374" href="#374">374</a> } |
| <a class="jxr_linenumber" name="375" href="#375">375</a> |
| <a class="jxr_linenumber" name="376" href="#376">376</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="377" href="#377">377</a> <strong class="jxr_keyword">int</strong> tpos = description.indexOf(<span class="jxr_string">" of table "</span>); |
| <a class="jxr_linenumber" name="378" href="#378">378</a> <strong class="jxr_keyword">int</strong> ipos = description.indexOf(<span class="jxr_string">" of index "</span>); |
| <a class="jxr_linenumber" name="379" href="#379">379</a> <strong class="jxr_keyword">int</strong> ppos = description.indexOf('('); |
| <a class="jxr_linenumber" name="380" href="#380">380</a> <strong class="jxr_keyword">int</strong> start = -1; |
| <a class="jxr_linenumber" name="381" href="#381">381</a> <strong class="jxr_keyword">if</strong> ((tpos > 0 && tpos < ipos) || ipos < 1) { |
| <a class="jxr_linenumber" name="382" href="#382">382</a> <strong class="jxr_keyword">if</strong> (tpos > -1) { |
| <a class="jxr_linenumber" name="383" href="#383">383</a> start = tpos + 10; |
| <a class="jxr_linenumber" name="384" href="#384">384</a> } |
| <a class="jxr_linenumber" name="385" href="#385">385</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="386" href="#386">386</a> <strong class="jxr_keyword">if</strong> (ppos > -1) { |
| <a class="jxr_linenumber" name="387" href="#387">387</a> start = ppos + 1; |
| <a class="jxr_linenumber" name="388" href="#388">388</a> } |
| <a class="jxr_linenumber" name="389" href="#389">389</a> } |
| <a class="jxr_linenumber" name="390" href="#390">390</a> <strong class="jxr_keyword">if</strong> (start > -1) { |
| <a class="jxr_linenumber" name="391" href="#391">391</a> tableName = description.substring(start); |
| <a class="jxr_linenumber" name="392" href="#392">392</a> |
| <a class="jxr_linenumber" name="393" href="#393">393</a> <strong class="jxr_keyword">boolean</strong> inQuotes = false; |
| <a class="jxr_linenumber" name="394" href="#394">394</a> <strong class="jxr_keyword">int</strong> theBeginOffset = 0; |
| <a class="jxr_linenumber" name="395" href="#395">395</a> <strong class="jxr_keyword">boolean</strong> inDoubleDoubleQuotes = false; |
| <a class="jxr_linenumber" name="396" href="#396">396</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> theCurrentOffset = 0; theCurrentOffset < tableName.length(); theCurrentOffset++) { |
| <a class="jxr_linenumber" name="397" href="#397">397</a> <strong class="jxr_keyword">char</strong> theCharacter = tableName.charAt(theCurrentOffset); |
| <a class="jxr_linenumber" name="398" href="#398">398</a> |
| <a class="jxr_linenumber" name="399" href="#399">399</a> <strong class="jxr_keyword">switch</strong> (theCharacter) { |
| <a class="jxr_linenumber" name="400" href="#400">400</a> <strong class="jxr_keyword">case</strong> '"': { |
| <a class="jxr_linenumber" name="401" href="#401">401</a> <strong class="jxr_keyword">if</strong> (inQuotes) { |
| <a class="jxr_linenumber" name="402" href="#402">402</a> <strong class="jxr_keyword">if</strong> (tableName.charAt(theCurrentOffset + 1) != '"') { |
| <a class="jxr_linenumber" name="403" href="#403">403</a> <strong class="jxr_keyword">if</strong> (inDoubleDoubleQuotes) { |
| <a class="jxr_linenumber" name="404" href="#404">404</a> inDoubleDoubleQuotes = !inDoubleDoubleQuotes; |
| <a class="jxr_linenumber" name="405" href="#405">405</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="406" href="#406">406</a> inQuotes = !inQuotes; |
| <a class="jxr_linenumber" name="407" href="#407">407</a> } |
| <a class="jxr_linenumber" name="408" href="#408">408</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="409" href="#409">409</a> inDoubleDoubleQuotes = !inDoubleDoubleQuotes; |
| <a class="jxr_linenumber" name="410" href="#410">410</a> } |
| <a class="jxr_linenumber" name="411" href="#411">411</a> } <strong class="jxr_keyword">else</strong> { |
| <a class="jxr_linenumber" name="412" href="#412">412</a> inQuotes = !inQuotes; |
| <a class="jxr_linenumber" name="413" href="#413">413</a> } |
| <a class="jxr_linenumber" name="414" href="#414">414</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="415" href="#415">415</a> } |
| <a class="jxr_linenumber" name="416" href="#416">416</a> <strong class="jxr_keyword">case</strong> ' ': |
| <a class="jxr_linenumber" name="417" href="#417">417</a> <strong class="jxr_keyword">case</strong> ')': { |
| <a class="jxr_linenumber" name="418" href="#418">418</a> <strong class="jxr_keyword">if</strong> (!inQuotes) { |
| <a class="jxr_linenumber" name="419" href="#419">419</a> tableName = tableName.substring(theBeginOffset, theCurrentOffset); |
| <a class="jxr_linenumber" name="420" href="#420">420</a> theBeginOffset = theCurrentOffset + 1; |
| <a class="jxr_linenumber" name="421" href="#421">421</a> } |
| <a class="jxr_linenumber" name="422" href="#422">422</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="423" href="#423">423</a> } |
| <a class="jxr_linenumber" name="424" href="#424">424</a> <strong class="jxr_keyword">default</strong>: { |
| <a class="jxr_linenumber" name="425" href="#425">425</a> <strong class="jxr_keyword">break</strong>; |
| <a class="jxr_linenumber" name="426" href="#426">426</a> } |
| <a class="jxr_linenumber" name="427" href="#427">427</a> } |
| <a class="jxr_linenumber" name="428" href="#428">428</a> |
| <a class="jxr_linenumber" name="429" href="#429">429</a> } |
| <a class="jxr_linenumber" name="430" href="#430">430</a> } |
| <a class="jxr_linenumber" name="431" href="#431">431</a> } |
| <a class="jxr_linenumber" name="432" href="#432">432</a> <strong class="jxr_keyword">return</strong> tableName; |
| <a class="jxr_linenumber" name="433" href="#433">433</a> } |
| <a class="jxr_linenumber" name="434" href="#434">434</a> |
| <a class="jxr_linenumber" name="435" href="#435">435</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> CreateSummary(ArrayList<QueryPlanData> qpa) |
| <a class="jxr_linenumber" name="436" href="#436">436</a> { |
| <a class="jxr_linenumber" name="437" href="#437">437</a> <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">null</strong> == qpa) |
| <a class="jxr_linenumber" name="438" href="#438">438</a> { |
| <a class="jxr_linenumber" name="439" href="#439">439</a> <em class="jxr_comment">// Need to regenerate query plan array as earlier code had a bug if explain was</em> |
| <a class="jxr_linenumber" name="440" href="#440">440</a> <em class="jxr_comment">// called multiple times for a query. QueryPlanArray would just keep growing ...</em> |
| <a class="jxr_linenumber" name="441" href="#441">441</a> <strong class="jxr_keyword">this</strong>.QueryPlanArray.clear(); |
| <a class="jxr_linenumber" name="442" href="#442">442</a> |
| <a class="jxr_linenumber" name="443" href="#443">443</a> <strong class="jxr_keyword">if</strong> (0 >= planStepsHT.size()) |
| <a class="jxr_linenumber" name="444" href="#444">444</a> <strong class="jxr_keyword">return</strong>; |
| <a class="jxr_linenumber" name="445" href="#445">445</a> |
| <a class="jxr_linenumber" name="446" href="#446">446</a> <em class="jxr_comment">// Cache away the explain data</em> |
| <a class="jxr_linenumber" name="447" href="#447">447</a> <em class="jxr_comment">//for (DictionaryEntry de : planStepsHT)</em> |
| <a class="jxr_linenumber" name="448" href="#448">448</a> <strong class="jxr_keyword">for</strong>(Enumeration e = planStepsHT.keys(); e.hasMoreElements();) |
| <a class="jxr_linenumber" name="449" href="#449">449</a> { |
| <a class="jxr_linenumber" name="450" href="#450">450</a> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> qdp = (QueryPlanData)planStepsHT.get(e.nextElement()); |
| <a class="jxr_linenumber" name="451" href="#451">451</a> |
| <a class="jxr_linenumber" name="452" href="#452">452</a> <em class="jxr_comment">//Store the plan item in the plan array</em> |
| <a class="jxr_linenumber" name="453" href="#453">453</a> <strong class="jxr_keyword">this</strong>.QueryPlanArray.add(qdp); |
| <a class="jxr_linenumber" name="454" href="#454">454</a> } |
| <a class="jxr_linenumber" name="455" href="#455">455</a> |
| <a class="jxr_linenumber" name="456" href="#456">456</a> qpa = <strong class="jxr_keyword">this</strong>.QueryPlanArray; |
| <a class="jxr_linenumber" name="457" href="#457">457</a> } |
| <a class="jxr_linenumber" name="458" href="#458">458</a> |
| <a class="jxr_linenumber" name="459" href="#459">459</a> |
| <a class="jxr_linenumber" name="460" href="#460">460</a> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">PlanSummaryInfo</a> psi = <strong class="jxr_keyword">new</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">PlanSummaryInfo</a>(); |
| <a class="jxr_linenumber" name="461" href="#461">461</a> |
| <a class="jxr_linenumber" name="462" href="#462">462</a> <strong class="jxr_keyword">for</strong>(<a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> qpd : qpa) |
| <a class="jxr_linenumber" name="463" href="#463">463</a> { |
| <a class="jxr_linenumber" name="464" href="#464">464</a> psi.totalOperators++; |
| <a class="jxr_linenumber" name="465" href="#465">465</a> String Operator = qpd.theOperator; |
| <a class="jxr_linenumber" name="466" href="#466">466</a> |
| <a class="jxr_linenumber" name="467" href="#467">467</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"ESP_EXCHANGE"</span>)) |
| <a class="jxr_linenumber" name="468" href="#468">468</a> { |
| <a class="jxr_linenumber" name="469" href="#469">469</a> psi.totalEspExchanges++; |
| <a class="jxr_linenumber" name="470" href="#470">470</a> |
| <a class="jxr_linenumber" name="471" href="#471">471</a> <em class="jxr_comment">//Get number of child processes</em> |
| <a class="jxr_linenumber" name="472" href="#472">472</a> <strong class="jxr_keyword">try</strong> |
| <a class="jxr_linenumber" name="473" href="#473">473</a> { |
| <a class="jxr_linenumber" name="474" href="#474">474</a> String cpValue = retrieveDescriptionValueOf(<span class="jxr_string">"child_processes:"</span>, qpd.description); |
| <a class="jxr_linenumber" name="475" href="#475">475</a> psi.totalChildProcesses += Integer.parseInt(cpValue); |
| <a class="jxr_linenumber" name="476" href="#476">476</a> } |
| <a class="jxr_linenumber" name="477" href="#477">477</a> <strong class="jxr_keyword">catch</strong> (Exception e) |
| <a class="jxr_linenumber" name="478" href="#478">478</a> { |
| <a class="jxr_linenumber" name="479" href="#479">479</a> <em class="jxr_comment">//If this ever happens it means that someone in the Explain </em> |
| <a class="jxr_linenumber" name="480" href="#480">480</a> <em class="jxr_comment">//group changed a string in the Explain Plan output -- Dean</em> |
| <a class="jxr_linenumber" name="481" href="#481">481</a> <em class="jxr_comment">//Might be better to display a message that there is some incompatibility issues.</em> |
| <a class="jxr_linenumber" name="482" href="#482">482</a> psi.totalChildProcesses = -1; |
| <a class="jxr_linenumber" name="483" href="#483">483</a> } |
| <a class="jxr_linenumber" name="484" href="#484">484</a> } |
| <a class="jxr_linenumber" name="485" href="#485">485</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"SCAN"</span>)) |
| <a class="jxr_linenumber" name="486" href="#486">486</a> psi.totalScans++; |
| <a class="jxr_linenumber" name="487" href="#487">487</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"NESTED"</span>) && Operator.contains(<span class="jxr_string">"JOIN"</span>)) |
| <a class="jxr_linenumber" name="488" href="#488">488</a> { |
| <a class="jxr_linenumber" name="489" href="#489">489</a> psi.totalNestedJoins++; |
| <a class="jxr_linenumber" name="490" href="#490">490</a> psi.totalOverallJoins++; |
| <a class="jxr_linenumber" name="491" href="#491">491</a> } |
| <a class="jxr_linenumber" name="492" href="#492">492</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"HASH"</span>) && Operator.contains(<span class="jxr_string">"JOIN"</span>)) |
| <a class="jxr_linenumber" name="493" href="#493">493</a> { |
| <a class="jxr_linenumber" name="494" href="#494">494</a> psi.totalHashJoins++; |
| <a class="jxr_linenumber" name="495" href="#495">495</a> psi.totalOverallJoins++; |
| <a class="jxr_linenumber" name="496" href="#496">496</a> } |
| <a class="jxr_linenumber" name="497" href="#497">497</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"MERGE"</span>) && Operator.contains(<span class="jxr_string">"JOIN"</span>)) |
| <a class="jxr_linenumber" name="498" href="#498">498</a> { |
| <a class="jxr_linenumber" name="499" href="#499">499</a> psi.totalMergeJoins++; |
| <a class="jxr_linenumber" name="500" href="#500">500</a> psi.totalOverallJoins++; |
| <a class="jxr_linenumber" name="501" href="#501">501</a> } |
| <a class="jxr_linenumber" name="502" href="#502">502</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"SORT"</span>)) |
| <a class="jxr_linenumber" name="503" href="#503">503</a> { |
| <a class="jxr_linenumber" name="504" href="#504">504</a> psi.totalSorts++; |
| <a class="jxr_linenumber" name="505" href="#505">505</a> } |
| <a class="jxr_linenumber" name="506" href="#506">506</a> |
| <a class="jxr_linenumber" name="507" href="#507">507</a> <strong class="jxr_keyword">if</strong> (Operator.contains(<span class="jxr_string">"INSERT"</span>) || Operator.contains(<span class="jxr_string">"UPDATE"</span>) || Operator.contains(<span class="jxr_string">"DELETE"</span>)) |
| <a class="jxr_linenumber" name="508" href="#508">508</a> psi.totalIUDs++; |
| <a class="jxr_linenumber" name="509" href="#509">509</a> } |
| <a class="jxr_linenumber" name="510" href="#510">510</a> planSummaryInfo = psi; |
| <a class="jxr_linenumber" name="511" href="#511">511</a> } |
| <a class="jxr_linenumber" name="512" href="#512">512</a> |
| <a class="jxr_linenumber" name="513" href="#513">513</a> <em class="jxr_comment">/// <summary></em> |
| <a class="jxr_linenumber" name="514" href="#514">514</a> <em class="jxr_comment">/// This function stores the plan steps in and sets the root </em> |
| <a class="jxr_linenumber" name="515" href="#515">515</a> <em class="jxr_comment">/// to later aid in building a treeview</em> |
| <a class="jxr_linenumber" name="516" href="#516">516</a> <em class="jxr_comment">/// </summary></em> |
| <a class="jxr_linenumber" name="517" href="#517">517</a> <em class="jxr_comment">/// <param name="planDataArray"></param></em> |
| <a class="jxr_linenumber" name="518" href="#518">518</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> SavePlanSteps(ArrayList planDataArray) |
| <a class="jxr_linenumber" name="519" href="#519">519</a> { |
| <a class="jxr_linenumber" name="520" href="#520">520</a> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> qdp = <strong class="jxr_keyword">null</strong>; |
| <a class="jxr_linenumber" name="521" href="#521">521</a> planStepsHT.clear(); |
| <a class="jxr_linenumber" name="522" href="#522">522</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i != planDataArray.size(); i++) |
| <a class="jxr_linenumber" name="523" href="#523">523</a> { |
| <a class="jxr_linenumber" name="524" href="#524">524</a> qdp = (QueryPlanData)planDataArray.get(i); |
| <a class="jxr_linenumber" name="525" href="#525">525</a> |
| <a class="jxr_linenumber" name="526" href="#526">526</a> <strong class="jxr_keyword">int</strong> seqNum = getIntValue(qdp.sequenceNumber); |
| <a class="jxr_linenumber" name="527" href="#527">527</a> <strong class="jxr_keyword">if</strong> (0 < seqNum) |
| <a class="jxr_linenumber" name="528" href="#528">528</a> { |
| <a class="jxr_linenumber" name="529" href="#529">529</a> |
| <a class="jxr_linenumber" name="530" href="#530">530</a> planStepsHT.put(seqNum, qdp); |
| <a class="jxr_linenumber" name="531" href="#531">531</a> |
| <a class="jxr_linenumber" name="532" href="#532">532</a> String operatorName = qdp.theOperator; |
| <a class="jxr_linenumber" name="533" href="#533">533</a> <strong class="jxr_keyword">if</strong> ((<strong class="jxr_keyword">null</strong> != operatorName) && |
| <a class="jxr_linenumber" name="534" href="#534">534</a> (<span class="jxr_string">"ROOT"</span>.equals(operatorName.trim().toUpperCase()))) |
| <a class="jxr_linenumber" name="535" href="#535">535</a> rootPlan = qdp; |
| <a class="jxr_linenumber" name="536" href="#536">536</a> } |
| <a class="jxr_linenumber" name="537" href="#537">537</a> } |
| <a class="jxr_linenumber" name="538" href="#538">538</a> } |
| <a class="jxr_linenumber" name="539" href="#539">539</a> |
| <a class="jxr_linenumber" name="540" href="#540">540</a> <em class="jxr_comment">/// <summary></em> |
| <a class="jxr_linenumber" name="541" href="#541">541</a> <em class="jxr_comment">/// Parse a string for int value</em> |
| <a class="jxr_linenumber" name="542" href="#542">542</a> <em class="jxr_comment">/// </summary></em> |
| <a class="jxr_linenumber" name="543" href="#543">543</a> <em class="jxr_comment">/// <param name="s"></param></em> |
| <a class="jxr_linenumber" name="544" href="#544">544</a> <em class="jxr_comment">/// <returns>Returns -1 if parsing fails</returns></em> |
| <a class="jxr_linenumber" name="545" href="#545">545</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">int</strong> getIntValue(String s) |
| <a class="jxr_linenumber" name="546" href="#546">546</a> { |
| <a class="jxr_linenumber" name="547" href="#547">547</a> <strong class="jxr_keyword">int</strong> val = -1; |
| <a class="jxr_linenumber" name="548" href="#548">548</a> |
| <a class="jxr_linenumber" name="549" href="#549">549</a> <strong class="jxr_keyword">if</strong> ((<strong class="jxr_keyword">null</strong> == s) || (0 >= s.trim().length())) |
| <a class="jxr_linenumber" name="550" href="#550">550</a> <strong class="jxr_keyword">return</strong> -1; |
| <a class="jxr_linenumber" name="551" href="#551">551</a> |
| <a class="jxr_linenumber" name="552" href="#552">552</a> <strong class="jxr_keyword">try</strong> |
| <a class="jxr_linenumber" name="553" href="#553">553</a> { |
| <a class="jxr_linenumber" name="554" href="#554">554</a> val = Integer.parseInt(s.trim()); |
| <a class="jxr_linenumber" name="555" href="#555">555</a> |
| <a class="jxr_linenumber" name="556" href="#556">556</a> } |
| <a class="jxr_linenumber" name="557" href="#557">557</a> <strong class="jxr_keyword">catch</strong> (Exception e) |
| <a class="jxr_linenumber" name="558" href="#558">558</a> { |
| <a class="jxr_linenumber" name="559" href="#559">559</a> val = -1; |
| <a class="jxr_linenumber" name="560" href="#560">560</a> } |
| <a class="jxr_linenumber" name="561" href="#561">561</a> |
| <a class="jxr_linenumber" name="562" href="#562">562</a> <strong class="jxr_keyword">return</strong> val; |
| <a class="jxr_linenumber" name="563" href="#563">563</a> } |
| <a class="jxr_linenumber" name="564" href="#564">564</a> |
| <a class="jxr_linenumber" name="565" href="#565">565</a> <em class="jxr_comment">/// <summary></em> |
| <a class="jxr_linenumber" name="566" href="#566">566</a> <em class="jxr_comment">/// Retrieves the actual description value of an item in the Description field</em> |
| <a class="jxr_linenumber" name="567" href="#567">567</a> <em class="jxr_comment">/// the plan</em> |
| <a class="jxr_linenumber" name="568" href="#568">568</a> <em class="jxr_comment">/// </summary></em> |
| <a class="jxr_linenumber" name="569" href="#569">569</a> <em class="jxr_comment">/// <param name="descValue"></param></em> |
| <a class="jxr_linenumber" name="570" href="#570">570</a> <em class="jxr_comment">/// <param name="fullDescription"></param></em> |
| <a class="jxr_linenumber" name="571" href="#571">571</a> <em class="jxr_comment">/// <returns>String</returns></em> |
| <a class="jxr_linenumber" name="572" href="#572">572</a> <strong class="jxr_keyword">private</strong> String retrieveDescriptionValueOf(String descValue, String fullDescription) |
| <a class="jxr_linenumber" name="573" href="#573">573</a> { |
| <a class="jxr_linenumber" name="574" href="#574">574</a> <strong class="jxr_keyword">try</strong> |
| <a class="jxr_linenumber" name="575" href="#575">575</a> { |
| <a class="jxr_linenumber" name="576" href="#576">576</a> <strong class="jxr_keyword">int</strong> index = fullDescription.indexOf(descValue); |
| <a class="jxr_linenumber" name="577" href="#577">577</a> String str = fullDescription.substring(index); |
| <a class="jxr_linenumber" name="578" href="#578">578</a> String[] strs; |
| <a class="jxr_linenumber" name="579" href="#579">579</a> strs = str.split(<span class="jxr_string">" "</span>); |
| <a class="jxr_linenumber" name="580" href="#580">580</a> str = strs[1]; |
| <a class="jxr_linenumber" name="581" href="#581">581</a> <strong class="jxr_keyword">return</strong> str; |
| <a class="jxr_linenumber" name="582" href="#582">582</a> } |
| <a class="jxr_linenumber" name="583" href="#583">583</a> <strong class="jxr_keyword">catch</strong>(Exception e) |
| <a class="jxr_linenumber" name="584" href="#584">584</a> { |
| <a class="jxr_linenumber" name="585" href="#585">585</a> <strong class="jxr_keyword">return</strong> <span class="jxr_string">""</span>; |
| <a class="jxr_linenumber" name="586" href="#586">586</a> } |
| <a class="jxr_linenumber" name="587" href="#587">587</a> } |
| <a class="jxr_linenumber" name="588" href="#588">588</a> |
| <a class="jxr_linenumber" name="589" href="#589">589</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">QueryPlanData</a> { |
| <a class="jxr_linenumber" name="590" href="#590">590</a> <strong class="jxr_keyword">public</strong> String sequenceNumber; |
| <a class="jxr_linenumber" name="591" href="#591">591</a> <em class="jxr_comment">// public String statementName;</em> |
| <a class="jxr_linenumber" name="592" href="#592">592</a> <strong class="jxr_keyword">public</strong> String theOperator; |
| <a class="jxr_linenumber" name="593" href="#593">593</a> <strong class="jxr_keyword">public</strong> String leftChildSeqNum; |
| <a class="jxr_linenumber" name="594" href="#594">594</a> <strong class="jxr_keyword">public</strong> String rightChildSeqNum; |
| <a class="jxr_linenumber" name="595" href="#595">595</a> <strong class="jxr_keyword">public</strong> String tableName; |
| <a class="jxr_linenumber" name="596" href="#596">596</a> <strong class="jxr_keyword">public</strong> String cardinality; |
| <a class="jxr_linenumber" name="597" href="#597">597</a> <strong class="jxr_keyword">public</strong> String operatorCost; |
| <a class="jxr_linenumber" name="598" href="#598">598</a> <strong class="jxr_keyword">public</strong> String totalCost; |
| <a class="jxr_linenumber" name="599" href="#599">599</a> <strong class="jxr_keyword">public</strong> String detailCost; |
| <a class="jxr_linenumber" name="600" href="#600">600</a> <strong class="jxr_keyword">public</strong> String description; |
| <a class="jxr_linenumber" name="601" href="#601">601</a> <strong class="jxr_keyword">public</strong> String formattedCostDesc; |
| <a class="jxr_linenumber" name="602" href="#602">602</a> } |
| <a class="jxr_linenumber" name="603" href="#603">603</a> |
| <a class="jxr_linenumber" name="604" href="#604">604</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/trafodion/dcs/master/QueryPlanModel.html">PlanSummaryInfo</a> |
| <a class="jxr_linenumber" name="605" href="#605">605</a> { |
| <a class="jxr_linenumber" name="606" href="#606">606</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalOperators = 0; |
| <a class="jxr_linenumber" name="607" href="#607">607</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalEspExchanges = 0; |
| <a class="jxr_linenumber" name="608" href="#608">608</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalEspProcesses = 0; |
| <a class="jxr_linenumber" name="609" href="#609">609</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalScans = 0; |
| <a class="jxr_linenumber" name="610" href="#610">610</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalNestedJoins = 0; |
| <a class="jxr_linenumber" name="611" href="#611">611</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalHashJoins = 0; |
| <a class="jxr_linenumber" name="612" href="#612">612</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalMergeJoins = 0; |
| <a class="jxr_linenumber" name="613" href="#613">613</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalSorts = 0; |
| <a class="jxr_linenumber" name="614" href="#614">614</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalIUDs = 0; <em class="jxr_comment">//Total Inserts, Updates, Deletes</em> |
| <a class="jxr_linenumber" name="615" href="#615">615</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalOverallJoins = 0; <em class="jxr_comment">//Total of all join type operators</em> |
| <a class="jxr_linenumber" name="616" href="#616">616</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">int</strong> totalChildProcesses = 0; |
| <a class="jxr_linenumber" name="617" href="#617">617</a> } |
| <a class="jxr_linenumber" name="618" href="#618">618</a> |
| <a class="jxr_linenumber" name="619" href="#619">619</a> } |
| </pre> |
| <hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body> |
| </html> |
| |
