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

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.

 

 

SEE ALLAdd a note
YOU
Add your Comment
Template Design © VibeThemes. All rights reserved.