ttCompact

This procedure compacts both the permanent and temporary data partitions of the database.

ttCompact merges adjacent blocks of free space, but does not move any items that are allocated. Therefore, fragmentation that is caused by small unallocated blocks of memory surrounded by allocated blocks of memory is not eliminated by using ttCompact.

Required Privilege

This procedure requires the ADMIN privilege.

Related Views

This procedure has no related views.

Syntax

ttCompact()

Parameters

ttCompact has no parameters.

Result Set

ttCompact returns no results.

Examples

CALL ttCompact ();

Notes

Compacting data does not modify result addresses.