SQL Tuning Quiz

Practice Quiz

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.



Template Design © VibeThemes. All rights reserved.