Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> explain plan question
Given this:
Execution Plan
0 SELECT STATEMENT OptimizerOOSE 1 0 SORT (UNIQUE)
2 1 FILTER 3 2 TABLE ACCESS (FULL) OF 'PURCHASE RECORD' 4 2 SORT (AGGREGATE) 5 4 TABLE ACCESS (FULL) OF 'PURCHASE RECORD'
and if you don't know the query, what kind of information does this give
you?
Is this saying that if purchase record has 1000 rows, that the table
will
be scanned 1000 times (line 5), once for each row in line 3?