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
When the following statement executes, the database server generates
statistics on both the sales_rep and us_sales_rep tables:
UPDATE STATISTICS FORTABLE 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 FORTABLEONLY (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.