Filter
Top Products
SSL Placement
U929-J-Z125-9-76 165
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 08:58.55 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k05
PLACEMENT OPTIMIZATION
PLACEMENT OPTIMIZATION FOR SET set-name
set-name specifies the name of the set to be optimized as an access path. It must not be a
SYSTEM set. This entry is to be added to the member record type of the set.
As a result of this entry, UDS/SQL reserves sufficient storage space immediately after the
owner record (when storing it) to hold the following information:
– Number of member records as specified in the POPULATION clause (see the section
“Storage space requirements for member records” on page 141).
– If member records are owners in other sets:
all tables to be stored in the pages of these records using ATTACHED (see the sections
“MODE clause” on page 166 and “INDEX clause” on page 167).
A prerequisite is that placement has not been specified for the owner record type of the
specified set using:
– LOCATION MODE IS CALC
– MODE IS LIST or
– PLACEMENT OPTIMIZATION
In the case of a record type defined in the schema DDL with LOCATION MODE IS CALC,
PLACEMENT OPTIMIZATION generates indirect CALC pages.
If the set is defined with MODE IS LIST then PLACEMENT OPTIMIZATION is ignored.