<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../../docs.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2" src="../../docs.js"></script>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>
<table width="100%" class="lightblue" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a href="http://www.omnidex.com"><img src="../../images/flatlogo.gif" width="95" height="25" hspace="3" vspace="3" border="0"></a></td>
    <td><img src="../../images/omnidex.gif" width="109" height="25" hspace="3" vspace="3"></td>
    <td align="right" valign="top"><p class="banner"><a href="../../Contents.htm">Contents</a> 
        | <a href="../../Quick%20Links.htm">Quick Links</a></p></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="175" class="bar"><p class="banner">&nbsp;</p></td>
    <td align="right" class="bar"> <!-- InstanceBeginEditable name="Section Title" -->
      <h1>Optimization</h1>
      <!-- InstanceEndEditable --></td>
  </tr>
  <tr> 
    <td width="175" class="left1 lightblue"><img src="../../images/blank.gif" width="10" height="20"> 
    </td>
    <td valign="top" class="left1 lightblue">&nbsp; </td>
  </tr>
  <tr> 
    <td width="175" valign="top" class="left"><!-- InstanceBeginEditable name="leftnav" -->
      <p>left navigation</p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>The Explain Plan</h2>
      <p>The Explain Plan is a formatted report detailing how Omnidex will process 
        a query. It provides warnings and suggestions, optimization techniques 
        used and step-by-step details explaining exactly how the query was processed. 
        The Explain Plan is available through the Omnidex utility, ODXSQL.</p>
      <p><a href="#one">1-Pass Optimization</a></p>
      <p><a href="#deferred">Deferred Optimization</a></p>
      <p>The Explain Plan can be generated in several ways:</p>
      <ul>
        <li>Execute a select statement then execute the EXPLAIN command after 
          the rows have been displayed.<br>
          <span class="ex">&gt;select * from customers where company='systems'<br>
          ...<br>
          &gt;explain </span></li>
        <li>Execute the EXPLAIN command with a select statement as an argument.<br>
          <span class="ex">&gt;explain select * from customers where company='systems'</span></li>
        <li>Execute a select statement with the EXPLAINONLY option then execute 
          the EXPLAIN command. The rows will not be displayed.<br>
          <span class="ex">&gt;select * from customers where company='systems' 
          with explainonly<br>
          &gt;explain</span> </li>
        <li>Set AUTOEXPLAIN ON then execute a select statement. The rows will 
          not be displayed.<br>
          <span class="ex">&gt;set autoexplain on<br>
          &gt;select * from customers where company='systems'</span></li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="one"></a>1-Pass Optimization</h3>
      <p class="ex">&gt;SELECT COMPANY, STATE FROM CUSTOMERS WHERE CUSTOMER_NO 
        IN <br>
        &nbsp; &nbsp; (SELECT CUSTOMER_NO FROM ORDERS WHERE STATUS ='back')</p>
      <p class="ex">...</p>
      <p class="ex">&gt;EXPLAIN</p>
      <p>The Explain Plan is divided into two sections: SUMMARY and DETAILS.</p>
      <p class="ex">----------------------------------- SUMMARY -----------------------------------<br>
        Select COMPANY, \<br>
        &nbsp; &nbsp; &nbsp; &nbsp;STATE \<br>
        from&nbsp; &nbsp;CUSTOMERS \<br>
        where&nbsp; CUSTOMER_NO in \<br>
        &nbsp; &nbsp;&nbsp; &nbsp; (select CUSTOMER_NO \<br>
        &nbsp; &nbsp; &nbsp; &nbsp; from &nbsp; &nbsp;ORDERS \<br>
        &nbsp; &nbsp; &nbsp; &nbsp; where&nbsp; STATUS = 'back')</p>
      <p class="ex">Version: 4.0 Build 8G (Compiled Jan 30 2004 12:50:07)<br>
        Optimization: MDKQUAL<br>
        ----------------------------------- DETAILS -----------------------------------<br>
        Qualify (CUSTOMERS)ORDERS where STATUS = 'back' on 1 with NOAUTORESET<br>
        Join ORDERS using CUSTOMER_NO to (CUSTOMERS)CUSTOMERS using CUSTOMER_NO 
        on 1 \<br>
        &nbsp; &nbsp;with NOAUTORESET,COUNT<br>
        Fetchkeys $ROWID 1000 at a time on 1<br>
        &nbsp;Retrieve CUSTOMERS using $ROWID = $ODXID<br>
        &nbsp;Return CUSTOMERS.COMPANY, CUSTOMERS.STATE<br>
        -------------------------------------------------------------------------------</p>
      <p>The above example shows a nested query against the Orders sample database. 
        The SUMMARY section displays the SELECT statement formatted for clarity, 
        as well as Omnidex version information and the type of optimization used 
        in this query. MDKQUAL means that the query was processed as an MDK qualification.</p>
      <p>The DETAILS section explains each step taken to process this query. This 
        first line &quot;Qualify (CUSTOMERS)ORDERS ...&quot; means the criteria 
        of the inner query &quot;STATUS = 'back' &quot; was processed within the 
        RS domain of the indexes. &quot;on 1&quot; means the query was processed 
        on cursor 1. NOAUTORESET is a default setting that causes ODXSQL to retain 
        the qualified ID list for further refinement. Then the qualified rows 
        were joined to the CUSTOMERS table using the link field CUSTOMER_NO. Fetchkeys 
        $ROWID ... means Omnidex &quot;fetched&quot; the rowids of the qualified 
        records from the ORDERS table that have matching CUSTOMERS records. &quot;Retrieve 
        CUSTOMERS ... &quot; gets the rowids of the corresponding CUSTOMERS records.</p>
      <p>All of the processing up to this point has been entirely within the Omnidex 
        indexes. The next two steps, &quot;Retrieve CUSTOMERS...&quot; and &quot;Return 
        CUSTOMERS...&quot; retrieves and returns the select-list items. This is 
        the last step and the only step in which the database has been touched, 
        meaning the query was processed with 1-pass optimization.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="deferred"></a>Deferred Optimization</h3>
      <p class="ex">&gt;SELECT ACCT, COMPANY FROM PROSPECTS WHERE ACCT IN<br>
        &nbsp; &nbsp; (SELECT DISTINCT ACCT FROM ORDERS WHERE SOURCE = 1)</p>
      <p class="ex">...</p>
      <p class="ex">&gt;EXPLAIN</p>
      <p>The Explain Plan is divided into two sections: SUMMARY and DETAILS.</p>
      <p>&nbsp;</p>
      <p class="ex">----------------------------------- SUMMARY -----------------------------------<br>
        Select ACCT, \<br>
        &nbsp; &nbsp; &nbsp; &nbsp;COMPANY \<br>
        from&nbsp; &nbsp;PROSPECTS \<br>
        where&nbsp; ACCT in \<br>
        &nbsp; &nbsp;&nbsp; &nbsp; (select distinct ACCT \<br>
        &nbsp; &nbsp; &nbsp; &nbsp; from &nbsp; &nbsp;ORDERS \<br>
        &nbsp; &nbsp; &nbsp; &nbsp; where&nbsp; SOURCE = 1)</p>
      <p class="ex">Version: &nbsp; &nbsp; &nbsp;4.0 Build 8G (Compiled Jan 30 
        2004 12:50:07)<br>
        Optimization: MDKQUAL<br>
        Warnings: &nbsp; &nbsp; UNOPTIMIZED_CRITERIA, UNOPTIMIZED_SORT, SEQUENTIAL_SCAN<br>
        Notes: &nbsp; &nbsp; &nbsp; &nbsp;Filter on column SOURCE will not be 
        optimized because there is <br>
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; not an MDK index 
        installed on the column<br>
        ----------------------------------- DETAILS -----------------------------------<br>
        Processing subquery 1 into {SQ1}<br>
        &nbsp;Retrieve ORDERS sequentially<br>
        &nbsp;Filter ORDERS.SOURCE = 1<br>
        &nbsp;Pass to queue {1} [ORDERS.ACCT]<br>
        &nbsp;Sort {1} for DISTINCT [ORDERS.ACCT ASC]<br>
        &nbsp;Retrieve {1} sequentially<br>
        &nbsp;Returning subquery 1 into {SQ1}</p>
      <p class="ex">Qualify (PROSPECTS)PROSPECTS where ACCT = '{SQ1}' on 1 with 
        NOAUTORESET<br>
        Fetchkeys $ROWID 1000 at a time on 1<br>
        &nbsp;Retrieve PROSPECTS using $ROWID = $ODXID<br>
        &nbsp;Return PROSPECTS.ACCT, PROSPECTS.COMPANY<br>
        -------------------------------------------------------------------------------</p>
      <p>Notice that the SUMMARY section contains &quot;Warnings&quot; and &quot;Notes&quot;. 
        These indicate that there may be a problem optimizing some part of the 
        query. Also notice that &quot;Optimization&quot; says &quot;MDKQUAL&quot;, 
        indicating that at least part of the query is optimized. </p>
      <p>The first part of the DETAILS section shows the processing of the inner 
        query (subquery), which is shown as {SQ1}. Because the column &quot;SOURCE&quot;, 
        which is in a criteria predicate in the inner query, is not installed 
        with an MDK index, the inner query will not be optimized. Therefore, all 
        of the ORDERS records are retrieved then filtered to match the criteria 
        &quot;SOURCE = 1&quot;. The filtered rows are passed to a queue where 
        they are sorted ascending by ACCT. The sorted ORDERS records are then 
        retrieved and returned into a buffer {SQ1} for use as criteria for the 
        outer query.</p>
      <p>The last four steps are fully optimized because the ACCT column in the 
        PROSPECTS table is installed with an MDK index. The PROSPECTS records 
        are qualified using the ACCT numbers from the inner query, and the records 
        are returned.</p>
      <p>The problem encountered in this example can be fixed by installing an 
        MDK index on the ACCT column in the ORDERS table.</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --><P align="right"><a href="#">Top</a> </P>
	  </td>
  </tr>
  <tr>
    <td width="175" class="bbar">
<p>&nbsp;</p></td>
    <td align="right" valign="middle" class="bbar"> <p class="banner">Omnidex 
        Version 4.1 Build 1 - E10.04 - Dynamic Information Systems Corporation 
        - Copyright &copy; 2004</p></td>
  </tr>
</table>
<div class="menu0" id="m1" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');"> 
  <a href="../../index.htm">Home</a></div>      
<div class="menu0" id="m2" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');"> 
  <a href="../../Omnidex%20Concepts/Omnidex%20Overview.htm">Omnidex</a></div>      
<div class="menu0" id="m3" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');"> 
  <a href="../../Getting%20Started/Getting%20Started.htm">Getting Started </a></div>      
<div class="menu0" id="m4" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');"> 
  <a href="../../Development/Development.htm">Development</a></div>      
<div class="menu0" id="m5" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');"> 
  <a href="../../Utilities/Utilities.htm">Utilities</a></div>      
<div class="menu0" id="m6" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');"> 
  <a href="../../Appendix/Appendix.htm">Appendix</a></div>
    <td>&nbsp;</td>
  </tr>
</table> 
<table id="s1" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');">
  <tr> 
    <td id="s11" class="menu1" onMouseOver="changeClass('menu0','s11');" onMouseOut="changeClass('menu1','s11');"><a href="../../Whats%20New.htm">What's 
      New!</a></td>
  </tr>
  <tr> 
    <td id="s12" class="menu1" onMouseOver="changeClass('menu0','s12');" onMouseOut="changeClass('menu1','s12');"><a href="../../Quick%20Links.htm">Quick 
      Links</a></td>
  </tr>
  <tr> 
    <td id="s13" class="menu1" onMouseOver="changeClass('menu0','s13');" onMouseOut="changeClass('menu1','s13');"><a href="../../Contents.htm">Contents</a></td>
  </tr>
</table>
<table id="s2" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');">
  <tr> 
    <td id="s21" class="menu1" onMouseOver="changeClass('menu0','s21');" onMouseOut="changeClass('menu1','s21');"><a href="../../Omnidex%20Concepts/Features/Features.htm">Features</a></td>
  </tr>
  <tr> 
    <td id="s22" class="menu1" onMouseOver="changeClass('menu0','s22');" onMouseOut="changeClass('menu1','s22');"><a href="../../Omnidex%20Concepts/Indexing%20Strategies/Indexing%20Strategies.htm">Indexing 
      Strategies</a></td>
  </tr>
  <tr> 
    <td id="s23" class="menu1" onMouseOver="changeClass('menu0','s23');" onMouseOut="changeClass('menu1','s23');"><a href="../../Omnidex%20Concepts/Indexing%20Options/Indexing%20Options.htm">Indexing 
      Options </a></td>
  </tr>
  <tr> 
    <td id="s24" class="menu1" onMouseOver="changeClass('menu0','s24');" onMouseOut="changeClass('menu1','s24');"><a href="../../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Index 
      Maintenance </a></td>
  </tr>
  <tr> 
    <td id="s25" class="menu1" onMouseOver="changeClass('menu0','s25');" onMouseOut="changeClass('menu1','s25');"><a href="../../Omnidex%20Concepts/Partitioning/Partitioning.htm">Optimization</a></td>
  </tr>
  <tr> 
    <td id="s26" class="menu1" onMouseOver="changeClass('menu0','s26');" onMouseOut="changeClass('menu1','s26');"><a href="../../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Partitioning</a></td>
  </tr>
  <tr> 
    <td id="s27" class="menu1" onMouseOver="changeClass('menu0','s27');" onMouseOut="changeClass('menu1','s27');"><a href="../../Omnidex%20Concepts/Text/Omnidex%20Text.htm">Omnidex Text</a></td>
  </tr>
</table>
<table id="s3" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');">
  <tr> 
    <td id="s31" class="menu1" onMouseOver="changeClass('menu0','s31');" onMouseOut="changeClass('menu1','s31');"><a href="../../Getting%20Started/1%20-%20Installation%20and%20Setup.htm">Server 
      Setup Guides</a></td>
  </tr>
  <tr> 
    <td id="s32" class="menu1" onMouseOver="changeClass('menu0','s32');" onMouseOut="changeClass('menu1','s32');"><a href="../../Getting%20Started/Omnidex%20Client/Windows%20Client.htm">Windows 
      Client</a></td>
  </tr>
  <tr> 
    <td id="s33" class="menu1" onMouseOver="changeClass('menu0','s33');" onMouseOut="changeClass('menu1','s33');"><a href="../../Database%20Platforms/Supported%20Database%20Platforms.htm">Database 
      Platforms </a></td>
  </tr>
  <tr> 
    <td id="s34" class="menu1" onMouseOver="changeClass('menu0','s34');" onMouseOut="changeClass('menu1','s34');"><a href="../../Environment%20Catalog/Environment%20Catalog.htm">Environment 
      Catalog</a> </td>
  </tr>
</table>
<table id="s4" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');">
  <tr> 
    <td id="s41" class="menu1" onMouseOver="changeClass('menu0','s41');" onMouseOut="changeClass('menu1','s41');"><a href="../../SQL%20Reference/SQL%20Reference.htm">SQL 
      Reference</a> </td>
  </tr>
  <tr> 
    <td id="s42" class="menu1" onMouseOver="changeClass('menu0','s42');" onMouseOut="changeClass('menu1','s42');"><a href="../../Development/ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../../Development/JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../../Development/OmniAccess%20API/OmniAccess%20API.htm">OmniAccess 
      API</a></td>
  </tr>
  <tr> 
    <td id="s45" class="menu1" onMouseOver="changeClass('menu0','s45');" onMouseOut="changeClass('menu1','s45');"><a href="../../Development/Debugging/OMNIDEX_DEBUG.htm">Debugging</a></td>
  </tr>
</table>
<table id="s5" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');">
  <tr> 
    <td id="s51" class="menu1" onMouseOver="changeClass('menu0','s51');" onMouseOut="changeClass('menu1','s51');"><A href="../../Utilities/DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../../Utilities/DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../../Utilities/NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../../Utilities/OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../../Utilities/OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../../Utilities/ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../../Utilities/ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../../Utilities/ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../../Utilities/ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../../Utilities/ODXSQL/ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../../Utilities/REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../../Utilities/REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../../Utilities/SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../../Utilities/SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../../Utilities/VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../../Utilities/VIEWGEN/VIEWGEN.htm">VIEWGEN</a></td>
  </tr>
</table>
<table id="s6" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');">
  <tr> 
    <td id="s61" class="menu1" onMouseOver="changeClass('menu0','s61');" onMouseOut="changeClass('menu1','s61');"><a href="../../Appendix/Cardinality.htm">Cardinality</a></td>
  </tr>
  <tr> 
    <td id="s62" class="menu1" onMouseOver="changeClass('menu0','s62');" onMouseOut="changeClass('menu1','s62');"><a href="../../Appendix/Date%20Formats.htm">Date 
      Formats </a></td>
  </tr>
  <tr> 
    <td id="s63" class="menu1" onMouseOver="changeClass('menu0','s63');" onMouseOut="changeClass('menu1','s63');"><a href="../../Appendix/Environment%20Variables.htm">Environment 
      Variables </a></td>
  </tr>
  <tr> 
    <td id="s64" class="menu1" onMouseOver="changeClass('menu0','s64');" onMouseOut="changeClass('menu1','s64');"><a href="../../Appendix/File%20Name%20Handling.htm">File 
      Name Handling</a></td>
  </tr>
  <tr> 
    <td id="s65" class="menu1" onMouseOver="changeClass('menu0','s65');" onMouseOut="changeClass('menu1','s65');"><a href="../../Appendix/Glossary%20A.htm">Glossary</a></td>
  </tr>
  <tr> 
    <td id="s66" class="menu1" onMouseOver="changeClass('menu0','s66');" onMouseOut="changeClass('menu1','s66');"><a href="../../Appendix/Null.htm">Null</a></td>
  </tr>
  <tr> 
    <td id="s67" class="menu1" onMouseOver="changeClass('menu0','s67');" onMouseOut="changeClass('menu1','s67');"><a href="../../Appendix/OAGLOBAL.htm">OAGLOBAL</a></td>
  </tr>
  <tr> 
    <td id="s68" class="menu1" onMouseOver="changeClass('menu0','s68');" onMouseOut="changeClass('menu1','s68');"><a href="../../Appendix/Operating%20Limits.htm">Operating 
      Limits</a></td>
  </tr>
  <tr> 
    <td id="s69" class="menu1" onMouseOver="changeClass('menu0','s69');" onMouseOut="changeClass('menu1','s69');"><a href="../../Appendix/Provided%20Managed%20Synonym%20Lists.htm">Managed 
      Synonym Lists</a></td>
  </tr>
  <tr> 
    <td id="s70" class="menu1" onMouseOver="changeClass('menu0','s70');" onMouseOut="changeClass('menu1','s70');"><a href="../../Appendix/Reserved%20Words.htm">Reserved 
      Words</a></td>
  </tr>
  <tr> 
    <td id="s71" class="menu1" onMouseOver="changeClass('menu0','s71');" onMouseOut="changeClass('menu1','s71');"><a href="../../Appendix/Supported%20Datatypes.htm">Supported 
      Data Types</a></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
<!-- InstanceEnd --></html>
