Using the FOR TABLE ONLY Keywords

Use the FOR TABLE ONLY keywords to collect data for a single table within a hierarchy of typed tables. If you do not include the ONLY keyword immediately after FOR TABLE when the specified table has subtables, HCL OneDB™ creates distributions for that table and also for every subtable under it in the hierarchy.

For example, suppose your database has the typed table hierarchy that appears in Example of Typed Table Hierarchy, which shows a supertable named employee that has a subtable named sales_rep. The sales_rep table, in turn, has a subtable named us_sales_rep.
Figure 1: Example of Typed Table Hierarchy

begin figure description - This figure is described in the surrounding text - end figure description
When the following statement executes, the database server generates statistics on both the sales_rep and us_sales_rep tables:
UPDATE STATISTICS FOR TABLE sales_rep;
In contrast, the following example generates statistical data for each column in table sales_rep but does not act on tables employee or us_sales_rep:
UPDATE STATISTICS FOR TABLE ONLY (sales_rep);

If you specify FOR TABLE ONLY, as in this example, the identifier of the table (or owner.table) must be enclosed between parentheses.

Because neither of the previous examples specified the level at which to update the statistical data, the database server uses the LOW mode by default.