Databases Reference
In-Depth Information
16. In the next screenshot, we can see the results of the previous query:
17. Execute a query with an equality predicate:
SET AUTOT TRACE EXP
SELECT NAME FROM REVERSE_TEST WHERE ID = 100;
18. Now, we can see the execution plan of the previous query:
19. Execute a query with a range predicate:
SET AUTOT TRACE EXP
SELECT NAME FROM REVERSE_TEST WHERE ID BETWEEN 100 AND 110;
