Posted: 20 May 2016 5:41 EDT Last activity: 30 May 2016 5:40 EDT
Is it possible to disable writing to pc_history_work table
Currently we write ~ a million records per day into pc_history_work table but don't use this data for any purposes. Just not performance, this table also causes maintenance overload. For eg: currently this table currently of size 520GB and we don't use this data at all.
1) Is there any way we can disable writing to pc_history_table?
2) Does truncating this table affect any reports referring to this table?