What is the best order while creating maintenance jobs so that sql optimizer can pickup the best execution plan.
Daily i have 3 jobs configured to run in the midnight.
job1 : reorgising the indexes
job2 : integrity checks
job3 : update statistics
I believe if i execute the jobs in the below order makes sense , please correct me if am wrong.
Also, would like to know does index re-org will do auto update stats or do we need to create a separate job or maintenance plan ?
1. Check integrity checks
2. Re-organise all indexes
3. update statistics
Also, can anyone tell me whether index rebuild is better option or index reorganise is fine ?
Thanks in Advance.