• thanks TheSqlGuru for your reply.

    We dont use auto update. And is hard to find a "slow/off time" .. you know. We are thinking the best way to schedule to run in spare time.

    In our server test takes 14 hours to complete the job. (less resources and almost the same database size)