Corporation Video Gaming Accessories 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.
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.
Table A–8 Columns group Components
Field Description
Column name The columns in the table.