I wonder if there is some 'best practice' how many times a day the sp_updatestats (SQL db Content Manager) should run. Of course it 'depends' on certain things... but like what? Imports by the Content Porter I assume. But any other things?
At the moment we run sp_updatestats twice a day. Regarding the fact we do: - daily imports (let's say about 30 items) - new versions/update versions of components (200-300 a day) - any other behaviour in the database that sp_updatestats will improve?
I was thinking about changing it to run it every hour. Is that common?