Câu 3: C2090-614: DB2 10.1 Advanced DBA for Linux UNIX and Windows

Consider the following statement: Which indexes should be created for optimal query performance?

1. A. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
2. B. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
3. C. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno); — đáp án hiện tại
4. D. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER;