PRELOAD
Purpose
Loads certain tables or columns and the corresponding internal indexes from disk in case they are not in the database cache.
Because of Exasol's smart cache management, the command should rarely be used. It might affect overall system performance.
Prerequisite
Access to all tables by the ownership of the user or any of its roles or by any read/write system or object privileges.
Syntax
preload::=
Usage Notes
If you specify schemas or the complete database, the corresponding tables will be loaded into the cache.
Example