• 莫名其妙的Explain Plan


    两张表的建表语句:

    CREATE TABLE hy_emp
    (
    empno NUMBER(8,0) not null primary key,
    ename NVARCHAR2(60) not null,
    deptno NUMBER(8,0) not null,
    sal NUMBER(10,0) DEFAULT 0 not null 
    )
    
    
    CREATE TABLE hy_dept
    (
    deptno NUMBER(8,0) not null primary key,
    dname NVARCHAR2(60) not null
    )

    插值语句:

    insert into hy_dept(deptno,dname) values('1','Hr');
    insert into hy_dept(deptno,dname) values('2','Dev');
    insert into hy_dept(deptno,dname) values('3','Qa');
    insert into hy_dept(deptno,dname) values('4','Sales');
    insert into hy_dept(deptno,dname) values('5','Mng');
    
    insert into hy_emp(empno,ename,deptno,sal) values('1','Andy','1',1000);
    insert into hy_emp(empno,ename,deptno,sal) values('2','Bill','2',2000);
    insert into hy_emp(empno,ename,deptno,sal) values('3','Cindy','3',3000);
    insert into hy_emp(empno,ename,deptno,sal) values('4','Douglas','4',4000);
    insert into hy_emp(empno,ename,deptno,sal) values('5','Edinburg','5',5000);
    insert into hy_emp(empno,ename,deptno,sal) values('6','Felix','1',6000);
    insert into hy_emp(empno,ename,deptno,sal) values('7','Hellen','2',7000);
    insert into hy_emp(empno,ename,deptno,sal) values('8','Isis','3',8000);
    insert into hy_emp(empno,ename,deptno,sal) values('9','Jean','4',9000);
    insert into hy_emp(empno,ename,deptno,sal) values('10','King','5',10000);
    insert into hy_emp(empno,ename,deptno,sal) values('11','Mac','1',11000);

    单表的Explain plan还好,两张表的实在让人莫名其妙:

    留待日后分辨吧。

  • 相关阅读:
    浅谈线段树
    并查集最简单讲解
    mysql索引原理深度解析
    算法、数据结构可视化
    php算法题---对称的二叉树
    php算法题---连续子数组的最大和
    Jsoup一个简短的引论——采用Java抓取网页数据
    宏定义详细信息
    解决java.sql.SQLException: ORA-01789: query block has incorrect number of result columns
    BZOJ 2435 NOI2011 道路建设 BFS/DFS
  • 原文地址:https://www.cnblogs.com/heyang78/p/12122701.html
Copyright © 2020-2023  润新知