Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: explain plan question
Filter covers a multitude of sins, and one of them is a nested loop approach. In this case I think your analysis is correct.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
doug edmunds wrote in message <3a70705e_2_at_news.pacifier.com>... Given this:
Execution Plan
0 SELECT STATEMENT Optimizer=CHOOSE 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?