Oracle Application Software 10.1.3.4 Bedienungsanleitung PDF herunterladen (Seite 127)

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.

1 2 ... 122 123 124 125 126 127 128 129 130 131 132 ... 169 170

Keine Kommentare

Oracle Application Software 10.1.3.4 Bedienungsanleitung Seite 127