<!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="#column">By Column </a></p>
      <p><a href="#equal">Into Equal Partitions</a></p>
      <p><a href="#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> </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="#column"><img src="../../images/arrow2.gif" width="10" height="10" border="0">By 
        Column </a></p>
      <p><a href="#equal"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Into 
        Equal Partitions</a></p>
      <p><a href="#equalcolumn"><img src="../../images/arrow2.gif" width="10" height="10" border="0">By 
        Column into Equal Partitions</a></p>
      <p><a href="Example2.htm#validation"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Using 
        a Validation Column</a></p>
      <p><a href="Example2.htm#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="column" id="column"></a>Partition by Column</h3>
      <p>The table is partitioned into two partitions, because the status column 
        has only two unique values. This partitioning approach is ineffective 
        because 96% of the records are in the first partition. No performance 
        is achieved in this example.</p>
      <p>There may be circumstances when this approach is appropriate, for example, 
        partitioning on a YEAR column.</p>
      <p>This example is shown to demonstrate exactly how this approach affects 
        the partitions. See the third example below for a better, more effective 
        approach.</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 class="ex">&gt;partition orders by status in dat<br>
        Partitioned 200 rows into 2 partitions</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 STATUS into individual 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>
              SH </p></td>
          <td align="right"> <p class="ex">192<br>
              192</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">96.000%<br>
              96.000%</p></td>
          <td align="right"> <p class="ex">96.000%<br>
              96.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS02<br>
              CN </p></td>
          <td align="right"> <p class="ex">8<br>
              8</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">4.000%<br>
              4.000%</p></td>
          <td align="right"> <p class="ex">4.000%<br>
              4.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="equal" id="equal"></a>Into Equal Partitions</h3>
      <p> The next example shows partitioning a table into equal partitions, not 
        by column.</p>
      <p>By itself, this method of partitioning is not very effective because 
        all of the partitions will be searched for every query. It is shown to 
        demonstrate exactly how this method affects partitions. See the third 
        example below for a better partitioning approach.</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 in dat<br>
        Partitioned 200 rows into 5 partitions</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 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>
              ORDERS02<br>
              ORDERS03<br>
              ORDERS04<br>
              ORDERS05 </p></td>
          <td align="right"> <p class="ex">40<br>
              40<br>
              40<br>
              40<br>
              40</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              20.000%<br>
              20.000%<br>
              20.000%<br>
              20.000%</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              20.000%<br>
              20.000%<br>
              20.000%<br>
              20.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>
      <h3><a name="equalcolumn" id="equalcolumn"></a>Into Equal Partitions By 
        Column</h3>
      <p> The next example shows partitioning a table into equal partitions by 
        a column.</p>
      <p>This method combines the first two methods shown above. It is more effective 
        than both previous approaches because it limits the number of partitions, 
        the partitions are divided as evenly as possible, and unique values in 
        the partition qualifier to be stored together in a single partition. This 
        last item causes queries that specify criteria against the partition qualifier 
        to search only one partition.</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 product_no in dat<br>
        Partitioned 200 rows into 5 partitions</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>
              MPOP</p></td>
          <td align="right"> <p class="ex">40<br>
              9<br>
              9<br>
              8<br>
              8<br>
              6</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              4.500%<br>
              4.500%<br>
              4.000%<br>
              4.000%<br>
              4.000%</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS02<br>
              G523<br>
              DM20<br>
              P900<br>
              G520<br>
              IC9S<br>
              T750</p></td>
          <td align="right"> <p class="ex">39<br>
              7<br>
              7<br>
              7<br>
              7<br>
              6<br>
              5</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">19.500%<br>
              3.500%<br>
              3.500%<br>
              3.500%<br>
              3.500%<br>
              3.000%<br>
              2.500%</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS03<br>
              B290<br>
              B390<br>
              B455<br>
              P225<br>
              HO30<br>
              H400<br>
              P224<br>
              B190<br>
              BRSP<br>
            </p></td>
          <td align="right"> <p class="ex">40<br>
              5<br>
              5<br>
              5<br>
              5<br>
              5<br>
              5<br>
              4<br>
              4<br>
              2<br>
            </p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.000%<br>
              2.000%<br>
              1.000%<br>
            </p></td>
          <td align="right"> <p class="ex">20.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%<br>
              0.000%<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS04<br>
              H736<br>
              N820<br>
              N972<br>
              PH65<br>
              S100<br>
              OSER<br>
              HPMP<br>
              EDMP<br>
              DM23<br>
              C478<br>
              3MTP<br>
              GEHE</p></td>
          <td align="right"> <p class="ex">40<br>
              4<br>
              4<br>
              4<br>
              4<br>
              4<br>
              3<br>
              3<br>
              3<br>
              3<br>
              3<br>
              3<br>
              2</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.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.500%<br>
              1.500%<br>
              1.500%<br>
              1.000%</p></td>
          <td align="right"> <p class="ex">20.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%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS05<br>
              P160<br>
              L722<br>
              HLTC<br>
              L433<br>
              3SAD<br>
              MTAC<br>
              3DST<br>
              PBSP<br>
              SCFP<br>
              CGPP<br>
              BTCT<br>
              SSST<br>
              SWFL<br>
              AEWP<br>
              OSTC<br>
              AQPP<br>
              GTLC<br>
              3RGS<br>
              3P23<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>
              2<br>
              2<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<br>
              1<br>
              1</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.500%<br>
              1.500%<br>
              1.500%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.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%<br>
              0.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%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
          <td align="right"> <p class="ex">20.500%<br>
              0.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%<br>
              0.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%<br>
              0.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%<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>
      <!-- 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>
