DEPT table has index created on “dname ” column.
Oracle uses index while processing the below sql statment :
SELECT deptno ,dname
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.