What happens if a maintenance window closes before a jo…

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

A.
The job is terminated and the gathered statistics are not saved.

B.
The job is terminated but the gathered statistics are not published.

C.
The job continues to run until all statistics are gathered.

D.
The job is terminated and statistics for the remaining objects are collected the next time the
maintenance window opens.



Leave a Reply 0

Your email address will not be published. Required fields are marked *