topic Database compression practices in Data Management Questions https://community.esri.com/t5/data-management-questions/database-compression-practices/m-p/339527#M19289 <HTML><HEAD></HEAD><BODY><P>Based on ESRI's best practices for compressing a database (<A href="http://support.esri.com/cn/knowledgebase/techarticles/detail/29160" title="http://support.esri.com/cn/knowledgebase/techarticles/detail/29160">29160 - Compress a versioned database to state 0</A>), I created a script that completes all the tasks.&nbsp; </P><P></P><P>I am wondering though - If the SDE_Compress_Log start_state_count of a database is 1, is there any reason it would be necessary to compress the database, rebuild indexes, and update database statistics?</P></BODY></HTML> Fri, 17 Apr 2015 13:52:34 GMT MarieCline_Delgado 2015-04-17T13:52:34Z Database compression practices https://community.esri.com/t5/data-management-questions/database-compression-practices/m-p/339527#M19289 <HTML><HEAD></HEAD><BODY><P>Based on ESRI's best practices for compressing a database (<A href="http://support.esri.com/cn/knowledgebase/techarticles/detail/29160" title="http://support.esri.com/cn/knowledgebase/techarticles/detail/29160">29160 - Compress a versioned database to state 0</A>), I created a script that completes all the tasks.&nbsp; </P><P></P><P>I am wondering though - If the SDE_Compress_Log start_state_count of a database is 1, is there any reason it would be necessary to compress the database, rebuild indexes, and update database statistics?</P></BODY></HTML> Fri, 17 Apr 2015 13:52:34 GMT https://community.esri.com/t5/data-management-questions/database-compression-practices/m-p/339527#M19289 MarieCline_Delgado 2015-04-17T13:52:34Z