Oracle常用命令

--重新分析表
analyze table table1 compute statistics for table for all indexes for all indexed columns;
--解析执行计划
explain plan for select xx1,xx2,xx3,xx4,xx5 from table1 t1 where t1.xx1 = 'yyy';