Fujitsu UDS/SQL V2.5 - page 163

SSL Placement
U929-J-Z125-9-76 163
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\ud s\Manuale\en\udsent_e\uds ent.k05
5.4.1.2 Placement within a realm
Within a realm, data belonging to one set occurrence c an be stored contiguously. If, for
example, member records are stored as list, they are physically stored in one page until the
page is completely filled. The other possibil ities relate to the storage of member recor ds and
the associated tables in the proximity of the owner record.
These are:
– Natural optimization
Owner proximity for lists, pointer arrays, sort key tables, set SEARCH key tables and
member records
– PLACEMENT OPTIMIZATION
Owner proximity for member records
– MODE clause
Owner page contains pointer array or list
– INDEX clause
Owner page contains sort key table or set SEARCH key table