Hi,
I was wondering if there is a way to 'schedule' a regular Index rebuild. i.e. set up a, let's say, monthly scheduled task that will delete the existing index & rebuild from fresh (i know I can do this manually by ticking the error recovery box but need to automate this process).
I'm running in to regular issues with the indexes on several servers 'forgetting' reports.
Many thanks
Andrew