Databases Reference
In-Depth Information
In the following screenshot, you can see the execution plan of the query after executing step 7:
We can see a
FULL
TABLE
ACCESS
on the
CUSTOMERS
table, followed by a
SORT
ORDER
BY
STOPKEY
. The next step is to execute
COUNT
STOPKEY
over the
VIEW
created in the previous
steps, so we have a
SORT
operation inside the subquery.