January 4, 2023

GPDB7: Clustering AO/CO tables

In addition to heap tables, starting from GPDB 7, AO/CO tables can also be clustered. Motivation CLUSTER, in general, ensures that the blocks of a table are physically ordered by the column(s) belonging to a supplied index. It has a direct benefit for tables which loaded in an

Read More »