VIEW
Short Description
A view's query is run and the resulting rows are passed on to another operation.
Detailed Description​
A view is a stored query. The result set is not materialised, but is collated at run time. In this plan step, the view's query is run and the resulting rows are passed on to another operation.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.