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?
Question:
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
Options:
The job is terminated and the gathered statistics are not saved.
The job is terminated but the gathered statistics are not published.
The job continues to run until all statistics are gathered.
The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
Correct Answer
The Correct Answer for this Question is
The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.