... update statistics low 只更新表 UPDATE STATISTICS HIGH 数据分布和索引 UPDATE STATISTICS MEDIUM DISTRIBUTIONS ONLY 数据分布 ...
基于4个网页-相关网页
Run the command UPDATE STATISTICS HIGH against the database.
对数据库运行命令update STATISTICS HIGH。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
如果查询中有属于多列索引的连接列或过滤列,则使用UPDATE STATISTICS HIGH。
Therefore, UPDATE STATISTICS cannot be compared to executing the query itself unless it is run in the high mode.
因此,除非以high模式运行,否则UPDATE STATISTICS与执行查询本身是不能相提并论的。
应用推荐