SQL/MP / File                                       see System Quirks

 

 

The SQL/MP / File screen presents information about files.

 

A file is the physical entity where data or descriptive information is stored.

 

The Actual Index (ActIndx) column displays the number of index levels in the file at the time of the screen display.  This value does not come from the catalog.  A high number of index levels can affect System performance.  Sorting the screen by this column allows index levels to be quickly checked.