The database should be regularly tidied. There are two parts to the Tidying process. Some tidying requires for the system to be stopped - hence it is performed nightly, or perhaps once a week. Other tidying can be configured to run during normal working hours.
