4. SQL Statements : CALL VECTORWISE : CLEANUP_UNUSED_FILES Command
 
Share this page                  
CLEANUP_UNUSED_FILES Command
The CLEANUP_UNUSED_FILES command scans all locations recursively to find files that do not belong to any tables. It renames such files by adding "unused_" prefix. This system command can be executed on a working system.
You should remove these unused files only after making sure that the system is running correctly.
This command has the following format:
CALL VECTORWISE(CLEANUP_UNUSED_FILES)
Note:  CLEANUP_UNUSED_FILES is designed to be used in cases where files are not deleted due to a crash or bug. It does not mark unreleased files that may still be needed by a transaction. So using this system call may not help you to free space if there are long-running or hanging transactions in the system.