MEMORYANALYTICS

A SQLFire virtual table that provides information about the overhead and memory usage of user tables and indexes.

See Estimating Memory Requirements.
Table 1. MEMORYANALYTICS system table
Column Name Type Length Nullable Contents
SQLENTITY VARCHAR 64 No The full name of the table or index, as well as the names of the memory values displayed in the MEMORY column.
ID VARCHAR 128 No The SQLFire member to which the memory values apply.
MEMORY LONG VARCHAR 2147483647 No The actual memory values, separated by commas.