OPEN/CLOSE Efficiency
Specifying T for the PLNCLOSE= option for SQL Preprocessor (to close the access plan at unit of recovery end) causes any opened tables to close. The exception is when another unit of recovery is currently accessing the table.
If the ACCESS MUF startup option has been specified as NOOPT, and if the table is the last table open for an area, the area is "physically" closed by the operating system. We recommend that when ACCESS NOOPT has been specified, open tables that are frequently accessed with PLNCLOSE=T in a non-SQL User Requirements Table to avoid this overhead. This User Requirements Table need never be used, but it keeps the areas open.
Note: Plan binding uses the CA Datacom Datadictionary, the Schema Information Tables (SIT), and the Optimizer message table (SYSMSG) areas. Binding executes faster if there is a User Requirements Table that holds those areas open. The Temporary Table Manager (TTM) area should also be held open because it may be used during the execution of binding.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|