top of page
ALTER CLUSTER [ schema. ]cluster
{ physical_attributes_clause
| SIZE size_clause
| allocate_extent_clause
| deallocate_unused_clause
| { CACHE | NOCACHE }
} ...
[ parallel_clause ] ;
example
ALTER CLUSTER personnel
SIZE 1024 CACHE;
ALTER CLUSTER language
DEALLOCATE UNUSED KEEP 30 K;
bottom of page