Entering content frame

Background documentation Number of Physical Writes of Temporary Pages Locate the document in the library structure

Number of physical writes of temporary pages: <count>

Explanation

When temporary Structure linkdata pages are generated to build (buffer) result sets (in JOINS or ORDER BY statements, for example), the Structure linkdata cache is not large enough to accommodate the temporary pages, which have to be moved into the Structure linkdata area. However, these pages must be exported out of the data area again for the further processing of the SQL statement.

User Response

Find the statement that causes these large (buffer) result sets to be created, and check the access strategies for this statement.

Note

For information on creating optimized SQL statements, see the Structure linkSQL Optimizer documentation.

 

Leaving content frame