Oracle Application Software 10.1.3.4 Manuel d'utilisateur télécharger pdf (Page 129)

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).

1 2 ... 124 125 126 127 128 129 130 131 132 133 134 ... 169 170

Pas de commentaire

Oracle Application Software 10.1.3.4 Manuel d'utilisateur Page 129