052-48

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?
A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

  一个作业在你的数据库实例的自动维护窗口中为一些对象正在搜集优化统计信息,在一个特定的时间点,所有对象的统计信息还没有搜集完,维护窗口就关闭了,此时,这个作业被终止,剩下的统计信息的搜集将在下次维护窗口打开的时候继续搜集。

posted @ 2017-12-07 11:26  巴啦啦大魔王  阅读(83)  评论(0编辑  收藏  举报