PRELOAD

Purpose

This statement loads specified 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, this command should rarely be used as it may affect the 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.

Usage notes

If you specify schemas or the complete database, the corresponding tables will be loaded into the cache.

Example