Use the REPORT AREA=IXX option to generate an Index Report. The number of records indexed can be verified by generating an Index Report. You can generate a type A, B, or G Index Area Report at any time. These reports provide information about the entire index whether the database has a single index area or Multi-Dataset Index areas.
The statistics reported in a type G report are used by the SQL Mode for join optimization. If you are doing many INSERTs or DELETEs and you use joins, you want to keep these statistics current. The statistics are updated when the data area is loaded, when the Index Area is rebuilt, or when you execute a type G report with the UPDATE= keyword coded YES.
Generate types D and E at the direction of Technical Support only.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|