Which of the following is included in the SYSTEM$CLUSTERING_INFORMATION output?

• A. A histogram depicting the distribution of overlap depth for each micro-partition.
• B. The total number of rows in the table.
• C. The table's creation timestamp.
• D. The table's compression type.

Answer: (A)

The function SYSTEM$CLUSTERING_INFORMATION returns clustering-related metadata for a table, focusing on how well the data is organized by the clustering keys. A key piece of that output is a histogram that shows the distribution of overlap depth across micro-partitions. Overlap depth measures how many clustering-key ranges intersect a given micro-partition; the histogram lets you quickly gauge clustering quality—lower overlap depths generally indicate better clustering and faster pruning, while higher depths suggest the table may benefit from reclustering.

The other items listed aren’t part of this clustering diagnostic output. You won’t see the total row count, the table creation timestamp, or the compression type in SYSTEM$CLUSTERING_INFORMATION; those details come from different metadata sources or system views.