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
SQL
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.