One job is taking more time its nearly 10Hrs. This job update all the indexes in the database. DB size is 25GB, daily it will insert 10L records nearly. Due to this job remaining job getting failed daily.
Can anyone let me know that how to perform any tunning on this job to complete less than 5 Hrs. Is this possible??
Quick reponse will be appreciated.