然后列出DEPTNO,从而允许DB 2对第一列(EMPNO)执行直接索引查找,然后针对大于号扫描第二列(DEPTNO)。
And DEPTNO should be listed second, allowing DB2 to do a direct index lookup on the first column (EMPNO) and then a scan on the second (DEPTNO) for the greater-than.
然后列出DEPTNO,从而允许DB 2对第一列(EMPNO)执行直接索引查找,然后针对大于号扫描第二列(DEPTNO)。
And DEPTNO should be listed second, allowing DB2 to do a direct index lookup on the first column (EMPNO) and then a scan on the second (DEPTNO) for the greater-than.
应用推荐