<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Partitioning - ODXSQL Examples</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>Partitioning</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><a href="Example1.htm#column">By Column </a></p>
      <p><a href="Example1.htm#equal">Into Equal Partitions</a></p>
      <p><a href="Example1.htm#equalcolumn">By Column into Equal Partitions</a></p>
      <p><a href="Example2.htm#validation">Using a Validation Column</a></p>
      <p><a href="Example2.htm#expressions">Using Expressions</a></p>
      <p><a href="Example3.htm">Generate Environment File Entry</a></p>
      <p><a href="Example4.htm">Indexes</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="Partitioning.htm">Partitioning</a></p>
      <p><a href="Partitioning.htm#limits"><img src="../../images/blank.gif" width="15" height="10" border="0">Limitations</a></p>
      <p><a href="Partitioning.htm#updates"><img src="../../images/blank.gif" width="15" height="10" border="0">Data 
        Updates</a></p>
      <p><a href="Analysis.htm">1. Analysis</a></p>
      <p><a href="Partition%20the%20Table.htm">2. Partition the Table</a></p>
      <p> <a href="Environment%20File.htm">3. Environment File Entry</a></p>
      <p><a href="Indexing.htm">4. Indexing</a></p>
      <p><a href="Example1.htm">Examples</a></p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2 class="line">Examples</h2>
      <p>These examples demonstrate partitioning a table :</p>
      <p><a href="Example1.htm#column"><img src="../../images/arrow2.gif" width="10" height="10" border="0">By 
        Column </a></p>
      <p><a href="Example1.htm#equal"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Into 
        Equal Partitions</a></p>
      <p><a href="Example1.htm#equalcolumn"><img src="../../images/arrow2.gif" width="10" height="10" border="0">By 
        Column into Equal Partitions</a></p>
      <p><a href="#validation"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Using 
        a Validation Column</a></p>
      <p><a href="#expressions"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Using 
        Expressions</a></p>
      <p><a href="Example3.htm"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Generate 
        Environment File Entry</a></p>
      <p><a href="Partition%20the%20Table.htm"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Partition 
        the Table</a></p>
      <p> The &quot;By Column&quot; and &quot;Into Equal Partitions&quot; examples 
        are not very efficient approaches to partitioning but are shown to demonstrate 
        exactly how each individual action affects the partitioning. Combining 
        both methods, however, can produce a very effective partitioning scheme, 
        as shown in the &quot;By Column into Equal Partitions&quot; example.</p>
      <p>The &quot;Using a Validation Column&quot; and &quot;Using Expressions&quot; 
        examples are good demonstrations of flexible and effective partitioning 
        schemes.</p>
      <p>The orders table in these examples has 200 rows of order details. In 
        each example, notice the command &quot;view partition.rpt&quot;. This 
        command simply displays the contents of the partition.rpt text file generated 
        by ODXSQL when the PARTITION command is executed.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="validation" id="validation"></a>Using a Validation Column</h3>
      <p>In this example, the a list of &quot;valid&quot; product numbers is retrieved 
        from the database and exported to an OST (Omnidex Stand-alone Table) using 
        the ODXSQL EXPORT command. This OST is then &quot;ATTACHed&quot; and used 
        with the PARTITION command in a WITH options clause. </p>
      <p>When the data is partitioned, all records with &quot;invalid&quot; product 
        numbers will be stored in a partition together, while records with valid 
        product numbers will be stored in partitions according to the settings 
        in the PARTITION command. The partition with invalid product numbers can 
        be removed, updated with correct data, or ignored.</p>
      <p>The partition.rpt file is now slightly different from other example. 
        the &quot;Valid&quot; and &quot;Valid %&quot; columns have more meaningful 
        data in them, as shown below.</p>
      <p>Note that the &quot;in dat&quot; statement instructs ODXSQL to place 
        the partitions into the dat subdirectory of the current working directory. 
        This clause is optional.</p>
      <p>First, valid product numbers are selected and exported to an ost named 
        x. The physical export file name will be x.ost.</p>
      <p class="ex">&gt; export (select product_no) from products where product_no 
        &gt;= 'A') to x with ost, delete<br>
        93 rows exported to x</p>
      <p>Next, the ost is attached and named &quot;VALID&quot; so it can be referenced 
        in the PARTITION command's WITH clause.</p>
      <p class="ex">&gt; attach ost x as VALID<br>
        Table VALID attached</p>
      <p>Finally, the PARTITION command is executed using the WITH option VALIDATION_COLUMN='VALID.product_no'</p>
      <p class="ex">&gt;partition orders into 5 by product_no in dat with validation_column='valid.product_no'<br>
        Partitioned 200 rows into 5 partitions</p>
      <p>The records with valid product numbers are partitioned between the first 
        4 partitions. The records with invalid product numbers are grouped together 
        in the 5th partition.</p>
      <p class="ex">&gt;view partition.rpt</p>
      <table width="90%" border="0" cellspacing="0" cellpadding="0">
        <tr align="center"> 
          <td colspan="5"> <p class="ex">OmniAccess Partitioning Report<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">Database:<br>
              Table:<br>
              Approach: </p></td>
          <td colspan="4"><p class="ex">Star:<br>
              Orders:<br>
              200 rows split by PRODUCT_NO into 5 equal partitions<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">Partition Value<br>
              -----------------</p></td>
          <td align="right"> <p class="ex">Cardinality<br>
              -------------</p></td>
          <td align="right"> <p class="ex">Valid<br>
              -------</p></td>
          <td align="right"> <p class="ex">Total %<br>
              ---------</p></td>
          <td align="right"> <p class="ex">Valid %<br>
              ---------</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS01<br>
              H672<br>
              H100<br>
              A940<br>
              HL6P<br>
              G523<br>
              DM20<br>
              BRSP</p></td>
          <td align="right"> <p class="ex">50<br>
              9<br>
              9<br>
              8<br>
              8<br>
              7<br>
              7<br>
              2</p></td>
          <td align="right"> <p class="ex">Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
            </p></td>
          <td align="right"> <p class="ex">25.000%<br>
              4.500%<br>
              4.500%<br>
              4.000%<br>
              4.000%<br>
              3.500%<br>
              3.500%<br>
              1.000%</p></td>
          <td align="right"> <p class="ex">26.178%<br>
              4.712%<br>
              4.712%<br>
              4.188%<br>
              4.188%<br>
              3.665%<br>
              3.665%<br>
              1.047%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS02<br>
              P900<br>
              G520<br>
              MPOP<br>
              IC95<br>
              T750<br>
              B290<br>
              B390<br>
              B455<br>
              P224</p></td>
          <td align="right"> <p class="ex">50<br>
              7<br>
              7<br>
              6<br>
              6<br>
              5<br>
              5<br>
              5<br>
              5<br>
              4</p></td>
          <td align="right"> <p class="ex">Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
            </p></td>
          <td align="right"> <p class="ex">25.000%<br>
              3.500%<br>
              3.500%<br>
              3.000%<br>
              3.000%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.000%</p></td>
          <td align="right"> <p class="ex">26.178%<br>
              3.665%<br>
              3.665%<br>
              3.141%<br>
              3.141%<br>
              2.618%<br>
              2.618%<br>
              2.618%<br>
              2.618%<br>
              2.094%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS03<br>
              P225<br>
              HO30<br>
              H400<br>
              B190<br>
              H736<br>
              N820<br>
              N972<br>
              PH65<br>
              S100<br>
              OSER<br>
              HPMP<br>
              EDMP<br>
              GEHE</p></td>
          <td align="right"> <p class="ex">50<br>
              5<br>
              5<br>
              5<br>
              4<br>
              4<br>
              4<br>
              4<br>
              4<br>
              4<br>
              3<br>
              3<br>
              3<br>
              2<br>
            </p></td>
          <td align="right"> <p class="ex">Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid</p></td>
          <td align="right"> <p class="ex">25.000%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.000%</p></td>
          <td align="right"> <p class="ex">26.178%<br>
              2.618%<br>
              2.618%<br>
              2.618%<br>
              2.094%<br>
              2.094%<br>
              2.094%<br>
              2.094%<br>
              2.094%<br>
              2.094%<br>
              1.571%<br>
              1.571%<br>
              1.571%<br>
              1.047%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS04<br>
              DM23<br>
              C478<br>
              P160<br>
              L722<br>
              HLTC<br>
              L433<br>
              MTAC<br>
              PBSP<br>
              SCFP<br>
              CGPP<br>
              BTCT<br>
              SSST<br>
              SWFL<br>
              AEWP<br>
              OSTC<br>
              AQPP<br>
              GTLC<br>
              BMLF<br>
              PDMP<br>
              PGMP<br>
              BMED<br>
              XPCP<br>
              S25P<br>
              SCDR<br>
              ACPC<br>
              ADLB<br>
              AAWP<br>
              GUOC<br>
              MMRB</p></td>
          <td align="right"> <p class="ex">41<br>
              3<br>
              3<br>
              3<br>
              3<br>
              2<br>
              2<br>
              2<br>
              2<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1</p></td>
          <td align="right"> <p class="ex">Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
              Valid<br>
            </p></td>
          <td align="right"> <p class="ex">20.500%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%<br>
              0.500%</p></td>
          <td align="right"> <p class="ex">20.500%<br>
              1.571%<br>
              1.571%<br>
              1.571%<br>
              1.571%<br>
              1.047%<br>
              1.047%<br>
              1.047%<br>
              1.047%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%<br>
              0.524%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS05<br>
              3MTP<br>
              3SAD<br>
              3DST<br>
              3RGS<br>
              3P23</p></td>
          <td align="right"> <p class="ex">9<br>
              3<br>
              2<br>
              2<br>
              1<br>
              1</p></td>
          <td align="right"> <p class="ex">Invalid<br>
              Invalid<br>
              Invalid<br>
              Invalid<br>
              Invalid<br>
              Invalid<br>
            </p></td>
          <td align="right"> <p class="ex">4.500%<br>
              1.500%<br>
              1.000%<br>
              1.000%<br>
              0.500%<br>
              0.500%</p></td>
          <td align="right"> <p class="ex">0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">-----------------<br>
              Total</p></td>
          <td align="right"> <p class="ex">-------------<br>
              200</p></td>
          <td align="right"> <p class="ex">-------</p></td>
          <td align="right"> <p class="ex">---------<br>
              100.00%</p></td>
          <td align="right"> <p class="ex">---------<br>
              100.00%</p></td>
        </tr>
        <tr> 
          <td colspan="2"><p class="ex">End of report</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
        </tr>
        <tr align="center"> 
          <td colspan="5"><p class="ex">---------------- End of file --------------</p></td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <p class="line">&nbsp;</p>
      <h3><a name="expressions" id="expressions"></a>Using Expressions</h3>
      <p> In this example, an expression is used to partition the table according 
        to the first letter in the product number. This is useful if the product 
        numbers or in some way codified. For example, all computers and computer 
        accessories begin with the letter C and furniture begins with the letter 
        F. This expression keeps these items grouped together in the partitions.</p>
      <p>Note that the &quot;in dat&quot; statement instructs ODXSQL to place 
        the partitions into the dat subdirectory of the current working directory. 
        This clause is optional.</p>
      <p> </p>
      <p class="ex">&gt;partition orders into 5 by &quot;substring(product_no 
        from 1 for 1)&quot; in dat<br>
        Partitioned 200 rows into 5 partitions</p>
      <p class="ex">&gt;view partition.rpt</p>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr align="center"> 
          <td colspan="5"> <p class="ex">OmniAccess Partitioning Report<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">Database:<br>
              Table:<br>
              Approach: </p></td>
          <td colspan="4"><p class="ex">Star:<br>
              Orders:<br>
              200 rows split by substring(product_no from 1 for 1) into 5 equal 
              partitions<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">Partition Value<br>
              -----------------</p></td>
          <td align="right"> <p class="ex">Cardinality<br>
              -------------</p></td>
          <td align="right"> <p class="ex">Valid<br>
              -------</p></td>
          <td align="right"> <p class="ex">Total %<br>
              ---------</p></td>
          <td align="right"> <p class="ex">Valid %<br>
              ---------</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS01<br>
              H</p></td>
          <td align="right"> <p class="ex">45<br>
              45</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">22.500%<br>
              22.500%</p></td>
          <td align="right"> <p class="ex">22.500%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS02<br>
              P<br>
              D<br>
              X</p></td>
          <td align="right"> <p class="ex">38<br>
              27<br>
              10<br>
              1</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">19.000%<br>
              13.500%<br>
              5.000%<br>
              0.500%</p></td>
          <td align="right"> <p class="ex">19.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS03<br>
              B<br>
              A</p></td>
          <td align="right"> <p class="ex">37<br>
              24<br>
              13</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">18.500%<br>
              12.000%<br>
              6.500%</p></td>
          <td align="right"> <p class="ex">18.500%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS04<br>
              G<br>
              M<br>
              S</p></td>
          <td align="right"> <p class="ex">36<br>
              18<br>
              9<br>
              9</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">18.000%<br>
              9.000%<br>
              4.500%<br>
              4.500%</p></td>
          <td align="right"> <p class="ex">18.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS05<br>
              3<br>
              N<br>
              I<br>
              L<br>
              T<br>
              O<br>
              C<br>
              E</p></td>
          <td align="right"> <p class="ex">44<br>
              9<br>
              8<br>
              6<br>
              5<br>
              5<br>
              4<br>
              4<br>
              3</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">22.000%<br>
              4.500%<br>
              4.000%<br>
              3.000%<br>
              2.500%<br>
              2.500%<br>
              2.000%<br>
              2.000%<br>
              1.500%</p></td>
          <td align="right"> <p class="ex">22.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">-----------------<br>
              Total</p></td>
          <td align="right"> <p class="ex">-------------<br>
              200</p></td>
          <td align="right"> <p class="ex">-------</p></td>
          <td align="right"> <p class="ex">---------<br>
              100.00%</p></td>
          <td align="right"> <p class="ex">---------<br>
              100.00%</p></td>
        </tr>
        <tr> 
          <td colspan="2"><p class="ex">End of report</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
        </tr>
        <tr align="center"> 
          <td colspan="5"><p class="ex">---------------- End of file --------------</p></td>
        </tr>
      </table>
      <p class="line">&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>
