SQL优化CheckList.pdf

SQL Check List 2002-9-25 1.0 2002-9-26 1.1 2002-10-8 1.2 × 1. SQL a) b) c) d) e) f) g) 2. a) SQL SQL b) SQL c) DBA ORACLE “ ” 3. a) SQL 2-3JOIN INSERT UPDATE “ ” b) c) 4. SQL a) ORACLE COST b) BUFFER_GETS DISK_GETS c) TKProf 5. a) × SELECT * FROM category WHERE id = ‘123’; × SELECT id FROM emp WHERE empno=8 SELECT id FROM emp WHERE empno=8 b) c) IS NULL IS NOT NULL × SELECT id FROM emp WHERE empno IS NULL;