Oracle Application Software 10.1.3.4 User Manual
Metadata for the IMS/DB Data Source
Advanced Tuning of the Metadata
A-9
Figure A–4
The Statistics tab
The Statistics tab comprises fields as listed in the following tables:
Use the Columns group box to specify cardinality for each of the columns in the table:
Table A–7
Statistics tab Components
Field
Description
No. of rows
The approximate number of rows in the table. If the value
is -1, then the number of rows in the table is unknown (a
value was not supplied and the update statistics utility
was not run to update the value). A value of 0 indicates
that this table is empty.
is -1, then the number of rows in the table is unknown (a
value was not supplied and the update statistics utility
was not run to update the value). A value of 0 indicates
that this table is empty.
No. of blocks
The approximate number of blocks in the table.
Note: If neither the number of rows nor the number of
blocks is specified for a table, queries over the table might
be executed in a nonoptimal manner.
blocks is specified for a table, queries over the table might
be executed in a nonoptimal manner.
Table A–8
Columns group Components
Field
Description
Column name
The columns in the table.