2015年1月16日

SQL TUNNING

摘要： In a Nested Loops Join, for example, the first accessed table is called the outer table and the second one the inner table. In a Hash Join, the first ... 阅读全文

posted @ 2015-01-16 19:48 tneduts 阅读(226) 评论(0) 推荐(0) 编辑

Oracle PLSQL

摘要： Oracle :show explain planselect * from table(dbms_xplan.display);EXPLAIN PLAN FOR statementsIn fact, in a typical data warehouse environments, a bitma... 阅读全文

posted @ 2015-01-16 10:44 tneduts 阅读(207) 评论(0) 推荐(0) 编辑

导航