REPORT (Generate Reports) › Index Area (IXX) Reports › Type G - Number of Records With Unique Key Values

Type G - Number of Records With Unique Key Values

To generate an Index Area report with statistics on records with unique key values, request an IXX report and specify TYPE=G.

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.