UNLOAD SCHEMA

Unload from RAM memory the indexes of all the tables that exist in the selected schema so that they don't take up any more space on RAM.

If a user sends a query that requires an unloaded index to be used, the necessary index will be automatically loaded from the disk.

Syntax

Syntax

UNLOAD SCHEMA [my_schema] ;

<my_schema>

The complete name of the Schema that you want to unload the table's indexes from.

Output

This SQL command does not return anything.