I’ve been having a lot of problems with my dwh analytics. I noticed that the archive tables are huge and one of them is corrupt.
Am I safe if I drop these tables and recreate them ? Or, can I delete some records safely and leave only a few days ?
My dwh_fact_bandwidth_usage_archive is occupying about 150G and has 1.6 B records
Thanks in advance for any help,