topic Re: How to use vaccum analyze&lt;table &gt; and where it should be used for initial or delta load in Get Started Discussions https://community.databricks.com/t5/get-started-discussions/how-to-use-vaccum-analyze-lt-table-gt-and-where-it-should-be/m-p/57065#M2191 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/97991">@Databricks_Work</a>&nbsp;, Vacuum and Analzye are two separate commands that are used for optimizing the queries but they perform two different operations.</P> <P>Vacuum is used to clear the stale data files in your delta table. Vacuum should be run after a optimize operation. We recommend to schedule a batch job to run optimize and vacuum. Generally, the preferred schedule is to run the job weekly but can be changed based on the use case.</P> <P>Analyze command is used to collect stats on the delta table. This helps in query planning like choosing the type of operation. This command is usually run on adhoc basis but can also be put as part of the daily job run.</P> Fri, 12 Jan 2024 12:46:16 GMT Lakshay 2024-01-12T12:46:16Z How to use vaccum analyze<table > and where it should be used for initial or delta load https://community.databricks.com/t5/get-started-discussions/how-to-use-vaccum-analyze-lt-table-gt-and-where-it-should-be/m-p/57058#M2189 Fri, 12 Jan 2024 11:12:06 GMT https://community.databricks.com/t5/get-started-discussions/how-to-use-vaccum-analyze-lt-table-gt-and-where-it-should-be/m-p/57058#M2189 Databricks_Work 2024-01-12T11:12:06Z Re: How to use vaccum analyze<table > and where it should be used for initial or delta load https://community.databricks.com/t5/get-started-discussions/how-to-use-vaccum-analyze-lt-table-gt-and-where-it-should-be/m-p/57065#M2191 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/97991">@Databricks_Work</a>&nbsp;, Vacuum and Analzye are two separate commands that are used for optimizing the queries but they perform two different operations.</P> <P>Vacuum is used to clear the stale data files in your delta table. Vacuum should be run after a optimize operation. We recommend to schedule a batch job to run optimize and vacuum. Generally, the preferred schedule is to run the job weekly but can be changed based on the use case.</P> <P>Analyze command is used to collect stats on the delta table. This helps in query planning like choosing the type of operation. This command is usually run on adhoc basis but can also be put as part of the daily job run.</P> Fri, 12 Jan 2024 12:46:16 GMT https://community.databricks.com/t5/get-started-discussions/how-to-use-vaccum-analyze-lt-table-gt-and-where-it-should-be/m-p/57065#M2191 Lakshay 2024-01-12T12:46:16Z