https://community.databricks.com/t5/data-engineering/i-have-a-table-with-150-columns-and-my-optimize-command-never/m-p/18217#M12048 <P>If the data in your table is huge, try to combine OPTIMIZE with WHERE so you only perform OPTIMIZE on a subset of the data rather than all data. see documentation <A href="https://docs.databricks.com/sql/language-manual/delta-optimize.html" alt="https://docs.databricks.com/sql/language-manual/delta-optimize.html" target="_blank">here</A>.</P> Mon, 28 Jun 2021 18:06:40 GMT amr 2021-06-28T18:06:40Z https://community.databricks.com/t5/data-engineering/i-have-a-table-with-150-columns-and-my-optimize-command-never/m-p/18216#M12047 Fri, 25 Jun 2021 22:43:20 GMT https://community.databricks.com/t5/data-engineering/i-have-a-table-with-150-columns-and-my-optimize-command-never/m-p/18216#M12047 brickster_2018 2021-06-25T22:43:20Z https://community.databricks.com/t5/data-engineering/i-have-a-table-with-150-columns-and-my-optimize-command-never/m-p/18217#M12048 <P>If the data in your table is huge, try to combine OPTIMIZE with WHERE so you only perform OPTIMIZE on a subset of the data rather than all data. see documentation <A href="https://docs.databricks.com/sql/language-manual/delta-optimize.html" alt="https://docs.databricks.com/sql/language-manual/delta-optimize.html" target="_blank">here</A>.</P> Mon, 28 Jun 2021 18:06:40 GMT https://community.databricks.com/t5/data-engineering/i-have-a-table-with-150-columns-and-my-optimize-command-never/m-p/18217#M12048 amr 2021-06-28T18:06:40Z