Skip to content

UNLOAD TABLE ​

Unload all the indexes a table from RAM memory 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 ​

sql
UNLOAD TABLE [mydb_name.]table ;

<table> ​

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

Output ​

This SQL command does not return anything.