topic Re: Does enabling Change Data Feed on a Delta table affect OPTIMIZE and ZORDER performance? in Data Engineering https://community.databricks.com/t5/data-engineering/does-enabling-change-data-feed-on-a-delta-table-affect-optimize/m-p/157085#M54502 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/230085">@GaneshI</a>&nbsp;Yes, some overhead is expected.&nbsp;Databricks recommends predicate-based OPTIMIZE for large tables and Liquid Clustering over ZORDER.</P> Sun, 17 May 2026 06:15:48 GMT Sumit_7 2026-05-17T06:15:48Z Does enabling Change Data Feed on a Delta table affect OPTIMIZE and ZORDER performance? https://community.databricks.com/t5/data-engineering/does-enabling-change-data-feed-on-a-delta-table-affect-optimize/m-p/157047#M54501 <P class="">Does enabling Change Data Feed on a Delta table affect OPTIMIZE and ZORDER performance?</P><P class="">After enabling CDF on several large Delta tables, our OPTIMIZE jobs are taking noticeably longer. Is this expected, and are there any tuning parameters to minimize the CDF metadata overhead during compaction?</P> Sat, 16 May 2026 09:17:44 GMT https://community.databricks.com/t5/data-engineering/does-enabling-change-data-feed-on-a-delta-table-affect-optimize/m-p/157047#M54501 GaneshI 2026-05-16T09:17:44Z Re: Does enabling Change Data Feed on a Delta table affect OPTIMIZE and ZORDER performance? https://community.databricks.com/t5/data-engineering/does-enabling-change-data-feed-on-a-delta-table-affect-optimize/m-p/157085#M54502 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/230085">@GaneshI</a>&nbsp;Yes, some overhead is expected.&nbsp;Databricks recommends predicate-based OPTIMIZE for large tables and Liquid Clustering over ZORDER.</P> Sun, 17 May 2026 06:15:48 GMT https://community.databricks.com/t5/data-engineering/does-enabling-change-data-feed-on-a-delta-table-affect-optimize/m-p/157085#M54502 Sumit_7 2026-05-17T06:15:48Z