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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with sql query speed. Explain plan included

Re: Help with sql query speed. Explain plan included

From: <JL19348_at_HOTMAIL.CO.UK>
Date: 18 Mar 2007 09:13:59 -0700
Message-ID: <1174234439.202646.138400@n59g2000hsh.googlegroups.com>

My apologies, here is the plan for my refreshed dataset. My database will not be renewed so we will not have to focus on a moving target again.
Thank you again
John

PLAN_TABLE_OUTPUT



Plan hash value: 2630738338
| Id  | Operation            | Name  | Rows  | Bytes |TempSpc| Cost

(%CPU)| Time |
-------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 23275 | 500K| | 18449
(7)| 00:03:42 |
|* 1 | FILTER | | | | | | | | 2 | HASH GROUP BY | | 23275 | 500K| 14M| 18449
(7)| 00:03:42 |
|* 3 | HASH JOIN | | 465K| 9M| | 17212
(8)| 00:03:27 |
|* 4 | INDEX RANGE SCAN | IDXE | 22 | 242 | | 3
(0)| 00:00:01 |
|* 5 | TABLE ACCESS FULL| TEST1 | 26M| 278M| | 16868

(6)| 00:03:23 |

PLAN_TABLE_OUTPUT



Predicate Information (identified by operation id):


   1 - filter(COUNT(*)>10)

   3 - access("T0"."QUESTIONNUMBER"="TX"."QUESTIONNUMBER" AND
              "T0"."ANSWER"="TX"."ANSWER")
       filter("T0"."RESIDENTID"<>"TX"."RESIDENTID")
   4 - access("T0"."RESIDENTID"=1486674)
   5 - filter("TX"."RESIDENTID"<>1486674)

22 rows selected. Received on Sun Mar 18 2007 - 11:13:59 CDT

Original text of this message

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