Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> explain plan question

explain plan question

From: doug edmunds <alt3_at_juno.com>
Date: Thu, 25 Jan 2001 10:28:44 -0800
Message-ID: <3a70705e 2@news.pacifier.com>

Given this:

Execution Plan


   0 SELECT STATEMENT Optimizer OOSE    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?

Received on Thu Jan 25 2001 - 12:28:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US