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?

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 and statistics for the remaining objects are collected the next time
the maintenance window opens.

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

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



Leave a Reply 3

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