@JefferyGregg - the sde.compress_log table will not get many rows even if you are running the sde compress every day for years. The question is do you need to keep the history if you are troubleshooting any sde compress issues, I suggest to not truncate the table, and instead delete rows older than 30 days, 60 days, 90 days, the period that you do not need the history anymore.
| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
