thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Clustering Depth

The average number of overlapping micro-partitions for given column values; lower depth means better clustering.

Definition

SYSTEM$CLUSTERING_INFORMATION and SYSTEM$CLUSTERING_DEPTH report clustering health. A depth near 1 means values are well co-located, and rising depth indicates degraded pruning.

Example

SELECT SYSTEM$CLUSTERING_INFORMATION('events', '(event_date)');

Exam tip

High average overlap and depth = poor clustering = less pruning.

Related terms