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.

You may also like...

Leave a Reply

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