User's Manual

Metadata for the IMS/DB Data Source
Advanced Tuning of the Metadata A-11
Use the Resolution group to specify the following:
Advanced Tab
The Advanced tab lets you enter information about the virtual view policy for arrays.
These parameters are valid only if you are using virtual array views. The
configurations made in this editor are for the selected table, only. The same parameters
are configured on the data source level in the data source editor.
Table A–10 Type group Components
Field Description
Estimated An estimation of the amount of statistical information
returned.
Estimated with rows An estimation of the amount of statistical information
returned. The estimate includes an estimation of the
number of rows in the table. Specify the number in the text
box. This number is used to shorten the time to produce
the statistics, assuming that the value specified here is the
correct value, or close to the correct value.
Exact The exact statistical information returned. Note that this
can be a lengthy task and can lead to disk space problems
with large tables.
Table A–11 Resolution group Components
Field Description
Default Only information about the table and indexes is collected.
Information for partial indexes and columns is not
collected.
All columns and
indexes
Information about the table, indexes, partial indexes and
columns is collected.
Select columns and
indexes
Enables you to select the columns and indexes for which
you want to collect statistics. In the enabled list of columns
or indexes, left click those columns you want included
(you can use shift-click and control-click to select a
number of columns or indexes).