Permits silver applications accumulate many tiny files after heavy updates. Which Delta maintenance command should they run to compact?

When permits silver applications accumulate many tiny files after heavy updates, the Delta maintenance command to compact them is OPTIMIZE on that heavily updated silver table. Small-file proliferation increases listing and read overhead for civic analysts and downstream jobs; OPTIMIZE rewrites data into larger files and restores efficient scan behavior on municipal permit tables. VACUUM on the heavily updated silver applications table to compact small files fails because it removes stale snapshots and old file versions rather than compacting small files, and it won't resolve the tiny-file problem on municipal permit tables. REORG on the heavily updated silver applications table to compact small files fails because reorganizing layout or purging soft-deleted data does not rewrite small files into larger files, and it leaves the tiny-file layout untouched for municipal permit tables. FSCK REPAIR on the heavily updated silver applications table to compact small files fails because checking consistency and repairing table metadata does not rewrite or compact the underlying small Delta files. Exam caveat: DP-750 Delta maintenance pairs OPTIMIZE with small-file remediation; do not confuse it with VACUUM, REORG, or FSCK REPAIR. Operational check: measure file counts on silver applications, run OPTIMIZE (with ZORDER if a common filter column applies), and confirm fewer files and improved read times for permits queries.