<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Indexing Strategies - Domains - Sorted Multi-Find</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>Indexing Strategies - Domains</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="#compare">Comparison</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="Domains.htm">Domains</a></p>
      <p><a href="Domains.htm#si">SI Domain</a></p>
      <p><a href="Domains.htm#rs">RS Domain</a></p>
      <p><a href="DR%20Domain.htm">DR Domain</a></p>
      <p><a href="DR%20Domain.htm#hybrid">Hybrid-DR Domain</a></p>
      <p>Sorted Multi-Find</p>
      <p><a href="Omnidex%20IDs%20by%20Domain.htm">Omnidex IDs by Domain</a></p>
      <p>&nbsp;</p>
      <p><a href="../Indexing%20Strategies.htm">Indexing Strategies</a></p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>Sorted Multi-Find</h2>
      <p>Sorted Multi-Find was originally developed for star schema designs, however, 
        it is equally effective in some deployments of relational tables. A sorted 
        multi-find is used to join tables in a DR domain.</p>
      <p>Because tables are built stand-alone, changes to the index installation 
        or other changes that may require the indexes to be rebuilt, apply to 
        each table individually. In a DR domain using multi-find, only one table 
        will need to be reindexed, where all tables in the MDK domain will be 
        rebuilt in an RS domain.</p>
      <p>Both methods are designed to allow indexed joins between table, specifically 
        parent-to-child joins. The following is a breakdown of the characteristics 
        of each method:</p>
      <p>Sorted Multi-Find was originally developed for star schema designs, however, 
        it is equally effective in some deployments of relational tables. A sorted 
        multi-find is used to join tables in a DR domain.</p>
      <p>Because tables are built stand-alone, changes to the index installation 
        or other changes that may require the indexes to be rebuilt, apply to 
        each table individually. In a DR domain using multi-find, only one table 
        will need to be reindexed, where all tables in the MDK domain will be 
        rebuilt in an RS domain.</p>
      <p>Both methods are designed to allow indexed joins between table, specifically 
        parent-to-child joins. The following is a breakdown of the characteristics 
        of each method:</p>
      <p class="line2">&nbsp;</p>
      <h6>RS Indexing</h6>
      <ul>
        <li> All tables in the MDK domain are built when the domain is specified. 
        </li>
        <li>8 bytes of the ID (uncompressed) are stored per keyword, per record 
          in the child table. </li>
        <li>Faster joins on larger parent qualify counts. </li>
        <li>ODXID column relates parent records to child records. </li>
        <li>May be preferable where the join field is wide. </li>
      </ul>
      <p class="line2">&nbsp;</p>
      <h6>Sorted Multi-Find</h6>
      <ul>
        <li>MDK indexes are built on each table. Changes to the index installation 
          or a need to rebuild indexes will apply to each table individually. 
        </li>
        <li>A child table does not have to be built in multiple domains to be 
          used for index joins to multiple parent tables in a query. </li>
        <li>4 bytes of the ID (uncompressed) are stored per keyword, per record 
          in the child table. </li>
        <li>Faster joins on smaller parent qualify counts. </li>
        <li>MDK parent key in the parent (or dimension) table is built with the 
          option B;IDSORT. </li>
        <li>MDK foreign key column in the child (or fact) table is indexed with 
          ;NT;NE;NP to enable sorted multi-find. </li>
        <li>Environment variable DISC_DBL_AMP must be set to any string to enable 
          sorted multi-find. </li>
        <li>Multiple dimension qualify lists can be merged to the fact in one 
          operation. </li>
        <li>MDK searches are faster on a child table because of the 4-byte ID's, 
          as opposed to the 8-byte ID's in an RS domain. </li>
        <li>Bitmap indexes are allowed on a child table. (Not allowed in an RS 
          domain)</li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="compare"></a>Comparison</h3>
      <p>In a recent test on a DISC customer's actual data, each method was found 
        to out-perform the other depending on the number of parent rows qualified 
        with the parent table criteria. The comparison involved a parent table 
        &quot;Customer&quot; with 743,000 rows joined with a child table &quot;Rating&quot; 
        with 6.1 million rows. The query returns a count from the child table 
        using criteria in the parent table.</p>
      <p class="ex">select count(*) from customer a, rating b where a.patron_number=b.patron_number 
        and a.birthday&gt;19200101</p>
      <p>The elapsed times reflect the slow performance of the server (AIX) and 
        would prove considerably faster with either method, on other platforms.</p>
      <p>The results of this comparison indicate that parent tables with fewer 
        than 200,000 rows should always use sorted multi-find.</p>
      <p>RS should be used when large dimension tables exist and parent-child 
        qualify speed is at a premium. A 10-million row dimension table joined 
        to a 100-million row fact table would be a definite candidate for RS.</p>
      <p>The sorted multi-find should also be used if the build window is contrained. 
        A full indexing with RS on the environment used in this comparison too 
        17 hours. With sorted multi-find, only 5 tables needed to be indexed, 
        which took 2 hours 9 minutes.</p>
<table width="100%" border="1" cellspacing="1" cellpadding="0">
                    <tr> 
                      <td width="20%" rowspan="2"> <h5 align="center">Parent Qualifying 
                          Count</h5></td>
                      <td colspan="2"><h5 align="center">RS</h5></td>
                      <td colspan="2"><h5 align="center">Multi-Find</h5></td>
                    </tr>
                    <tr> 
                      <td width="20%"> <h5 align="center">CPU time</h5></td>
                      <td width="20%"> <h5 align="center">Elapsed time</h5></td>
                      <td width="20%"> <h5 align="center">CPU time</h5></td>
                      <td width="20%"> <h5 align="center">Elapsed time</h5></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>683,355</p></td>
                      <td width="20%"><p>4.8</p></td>
                      <td width="20%"><p>10.6</p></td>
                      <td width="20%"><p>8.6</p></td>
                      <td width="20%"><p>18.4</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>4.7</p></td>
                      <td width="20%"><p>9.2</p></td>
                      <td width="20%"><p>8.6</p></td>
                      <td width="20%"><p>17.6</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>625,151</p></td>
                      <td width="20%"><p>4.3</p></td>
                      <td width="20%"><p>8.6</p></td>
                      <td width="20%"><p>8.2</p></td>
                      <td width="20%"><p>18.9</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>4.4</p></td>
                      <td width="20%"><p>8.8</p></td>
                      <td width="20%"><p>7.7</p></td>
                      <td width="20%"><p>15.3</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>522,923</p></td>
                      <td width="20%"><p>4.0</p></td>
                      <td width="20%"><p>7.7</p></td>
                      <td width="20%"><p>7.7</p></td>
                      <td width="20%"><p>15.1</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>4.0</p></td>
                      <td width="20%"><p>7.7</p></td>
                      <td width="20%"><p>7.7</p></td>
                      <td width="20%"><p>15.4</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>374,407</p></td>
                      <td width="20%"><p>3.4</p></td>
                      <td width="20%"><p>6.6</p></td>
                      <td width="20%"><p>5.0</p></td>
                      <td width="20%"><p>9.6</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>3.5</p></td>
                      <td width="20%"><p>6.6</p></td>
                      <td width="20%"><p>4.9</p></td>
                      <td width="20%"><p>9.5</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>218,356</p></td>
                      <td width="20%"><p>2.9</p></td>
                      <td width="20%"><p>5.8</p></td>
                      <td width="20%"><p>3.4</p></td>
                      <td width="20%"><p>6.4</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>2.9</p></td>
                      <td width="20%"><p>5.4</p></td>
                      <td width="20%"><p>3.4</p></td>
                      <td width="20%"><p>6.4</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>163,645</p></td>
                      <td width="20%"><p>3.0</p></td>
                      <td width="20%"><p>5.7</p></td>
                      <td width="20%"><p>2.8</p></td>
                      <td width="20%"><p>5.6</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>3.2</p></td>
                      <td width="20%"><p>7.1</p></td>
                      <td width="20%"><p>2.8</p></td>
                      <td width="20%"><p>5.2</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>90,415</p></td>
                      <td width="20%"><p>2.9</p></td>
                      <td width="20%"><p>5.4</p></td>
                      <td width="20%"><p>2.2</p></td>
                      <td width="20%"><p>4.0</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>2.9</p></td>
                      <td width="20%"><p>5.3</p></td>
                      <td width="20%"><p>2.1</p></td>
                      <td width="20%"><p>3.8</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>35,607</p></td>
                      <td width="20%"><p>2.8</p></td>
                      <td width="20%"><p>5.6</p></td>
                      <td width="20%"><p>1.7</p></td>
                      <td width="20%"><p>3.1</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>2.8</p></td>
                      <td width="20%"><p>5.4</p></td>
                      <td width="20%"><p>1.7</p></td>
                      <td width="20%"><p>3.1</p></td>
                    </tr>
                    <tr> 
                      <td width="20%"><p>3,448</p></td>
                      <td width="20%"><p>2.9</p></td>
                      <td width="20%"><p>7.9</p></td>
                      <td width="20%"><p>0.8</p></td>
                      <td width="20%"><p>1.4</p></td>
                    </tr>
                    <tr> 
                      <td width="20%">&nbsp;</td>
                      <td width="20%"><p>2.8</p></td>
                      <td width="20%"><p>5.4</p></td>
                      <td width="20%"><p>0.9</p></td>
                      <td width="20%"><p>1.3</p></td>
                    </tr>
                  </table>      <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>
