Practice Quiz
DEPT table has index created on “dname ” column.
Oracle uses index while processing the below sql statment :
SELECT deptno ,dname
FROM DEPT;
A Table is having 20 columns. 10 reports are created using this table.
For tuning purpose , how many indexes you suggest. Which is the best option.