如果在快照中没有成本增加的SQL查询,可以分析访问计划,以查看可以根据累积的数据进行哪些修改。
If there are no growing cost SQL queries in the snapshot, analyze the access plan to see which can be amended based on the accumulated data.
访问计划可以根据累积的数据进行更改。
该文件是累积的,换言之,如果SET EXPLAIN ON语句之后有多个SQL查询,每个查询的执行计划及其成本都会被追加到文件中,直到将之删除。
This file is cumulative, in other words, if you have multiple SQL queries after SET EXPLAIN on statement, each query execution plan and its costs would be appended to this file until it is removed.
应用推荐