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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply