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::=

Preload Statement

Usage Notes

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

Example

PRELOAD TABLE t(i);