How can I request that a TE load data and its indexes into its local memory?
NuoDB Transaction Engines (TE's) request data and indexes on an as-needed basis from available storage. They keep it in local TE memory as long as there room for it. When memory limits are reached, TE's release less frequently used local data thus freeing memory.
In most cases, optimum query performance is observed when data being accessed is available at the TE being accessed. This avoids disk, transfer, and load time from a storage manager or other TE in the database. Often users ask if it is possible to request loading of data and indexes prior to usage in order to maximize query performance (similar to warming a cache).
NuoDB does not support a specific command to do this but you may coerce loading (within memory limits) by running the ANALYZE SQL command on the table or indexes that you desire. This brings the desired objects into local memory and performance may be improved.