optimize

DE//AGENT currently lists 2 resources under optimize: 1 tutorial, 1 skill. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.

Documented learning objectives across these resources:

• Decide if a table needs OPTIMIZE from file stats — via Delta Optimization Advisor
• Choose Z-ORDER columns from query predicates — via Delta Optimization Advisor
• Know when liquid clustering beats partitioning — via Delta Optimization Advisor

These resources map to stage: Lakehouse (2). Follow the four-phase roadmap to place this topic inside a progression instead of learning it in isolation.

Every entry, its shape and its trust state — sorted by the registry's composite score. This table is the honest version of a marketing comparison: no sponsored placements, no unverifiable claims.

How scores are computed: source quality score.

Highest composite score first:

1. Delta Optimization Advisor score 34.9 — intermediate
2. Decide when a Delta table needs OPTIMIZE or Z-ORDER score 34.15 — beginner

Scores rank provenance, completeness and trust — read how verification works before adopting anything.

Start here if you're new: Decide when a Delta table needs OPTIMIZE or Z-ORDER.

Security-flagged entries: Delta Optimization Advisor (2 flags). Flags mean the record declares capabilities like credential use or write access — read the security posture on each page before connecting.

• Delta Optimization Advisor — Reads Delta table history and file statistics to decide between OPTIMIZE, Z-ORDER, liquid clustering and partitioning changes. details
• Decide when a Delta table needs OPTIMIZE or Z-ORDER — Apply the Delta Optimization Advisor's decision rules to one table: read file stats for the OPTIMIZE trigger, pick Z-ORDER columns from actual query predicates, weigh liquid cluste… details

Real install commands from the registry — read the source before running any of them:

npx de-agent-platform add delta-optimization-advisor

Delta Optimization Advisor — review first

Adjacent topics: z-order (2 shared), liquid-clustering (2 shared).

Study path: the roadmap places this topic in a progression · the scoring model explains the numbers · the trust rule catalog shows every security check these entries passed through.