QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics
Cause: The user attempted to add a workload statement that contains a table without statistics. Access Advisor requires all referenced tables to have valid statistics.
Action: Validate the workload statement and retry the operation.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-00792：指定的SQL语句无法存储在工作负载中，因为一个或多个表缺少统计信息,
.原因：用户尝试添加包含不带统计信息的表的工作负载语句。Access Advisor要求所有引用的表具有有效的统计信息。,
.操作：验证工作负载语句并重试操作。,
.

aiaiDBA

13718043309

010-86462881

QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

1 个回答

相似问题