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

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.