PL/SQL :: Basic Concepts
7. Which of the following is valid SQL for an Index?
Index is created to make the searches (select query) faster. But to use the index we need to write the SQL select statement using the column on which we created the Index.
Example: Create index indx1 on emp (empno). To use the benefits, we have to write select * from emp where empno > 0;