Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with sql query speed. Explain plan included
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
| 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
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