请教个关于explain plan 的问题:我先用analyze table,统计数据,然后做CBO的explain plan可是出现了错误,
explin plan for SELECT COUNT(*),SUM(p_retailprice), AVG(p_retailprice),
From part
Group by p_retailprice;
6899 rows selected.SQL> SQL> SQL> 2
PLAN_TABLE_output
Error: cannot fetch last explain plan from PLAN_TABLE1 row selected.
explin plan for SELECT COUNT(*),SUM(p_retailprice), AVG(p_retailprice),
From part
Group by p_retailprice;
6899 rows selected.SQL> SQL> SQL> 2
PLAN_TABLE_output
Error: cannot fetch last explain plan from PLAN_TABLE1 row selected.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货