Analyze

Rajasaiharish — Sat, 03 Oct 2026 08:12:47 GMT

How many types of analyze do we have for a UC delta table ? And how to check which type of ANALY

Re: Analyze

Rajasaiharish — Sat, 03 Oct 2026 09:05:23 GMT

How many types of analyze do we have for a UC delta table ? And how to check which type of ANALYZE ran for what table? i think total questions was not printed correctly

Re: Analyze

K_Anudeep — Sat, 03 Oct 2026 09:42:18 GMT

Hello @Rajasaiharish !

For a UC Delta table, there are three main ANALYZE command families:

COMPUTE STATISTICS — collects table/column statistics for the query optimiser.
COMPUTE DELTA STATISTICS — recomputes Delta file-level statistics used for data skipping.
COMPUTE STORAGE METRICS — calculates storage usage metrics.

There are three types of optimiser-stat collection sources, which you see on a UC delta table when ANALYZE is run:

MANUAL_ANALYZE - Someone (notebook, SQL editor, job, DLT that isn’t on the auto-stats write path) runs ANALYZE TABLE … COMPUTE STATISTICS.
AUTO_STATS - Stats are collected on write / ingest, not manually.
PREDICTIVE_ANALYZE - Predictive Optimization (maintenance-auto-compute) schedules ANALYZE.

You can run the query below to check the type of ANALYZE run on the table:

SHOW STATISTICS FROM catalog.schema.table AS JSON; SHOW STATISTICS FROM catalog.schema.table FOR ALL COLUMNS AS JSON;

Look at statistics.collection_source and statistics.created_at in the output to see what type of ANALYZE was run on the table

topic Analyze in Data Engineering

Analyze

Re: Analyze

Re: Analyze