trace 日志信息(不包括资源监控部分)
其中,
黑色加粗字体
表示步骤执行的开始,
蓝色字体
表示输出信息的解释
说明。
2012-12-27 18:34:20.961
Execution Plan
:
-- 打印执行计划,在计划中打印出各个
TempTable 表名,所属数据库以及别名
T:-1 = TABLE_ALIAS(T:0,"supplier:tpch/supplier")
T:-2 = TMP_TABLE(T:-1,"
supplier:tpch/supplier
")
-- 格式为“表名:所属数据库/
别名”,supplier 表属于数据库 tpch,该表别名为 supplier
T:-3 = TABLE_ALIAS(T:1,"lineitem:tpch/l1")
T:-2.JOIN(T:-3,"
lineitem:tpch/l1
")
T:-4 = TABLE_ALIAS(T:2,"orders:tpch/orders")
T:-2.JOIN(T:-4,"
orders:tpch/orders
")
T:-5 = TABLE_ALIAS(T:3,"nation:tpch/nation")
T:-2.JOIN(T:-5,"
nation:tpch/nation
")
LA:-2.0 = CREATE_LA(T:-2,PHYS_COL(T:-1,A:1))
A:-1 = T:-2.ADD_COLUMN(LA:-2.0,GROUP_BY,"s_name","ALL")
A:-2 = T:-2.ADD_COLUMN(<null>,COUNT,"numwait","ALL")
LA:-2.1 = CREATE_LA(T:-2,PHYS_COL(T:-2,A:-2))
T:-2.ADD_ORDER(LA:-2.1,DESC)
LA:-2.2 = CREATE_LA(T:-2,PHYS_COL(T:-2,A:-1))
T:-2.ADD_ORDER(LA:-2.2,ASC)
LA:-2.3 = CREATE_LA(T:-2,PHYS_COL(T:-1,A:0))
LA:-2.4 = CREATE_LA(T:-2,PHYS_COL(T:-3,A:2))