| full table scan [message #495436] |
Sat, 19 February 2011 02:35  |
 |
sathik123
Messages: 37
Registered: December 2010
Location: chennai
|
Member |
|
|
Hi
I am deleting row from the table.but it is taking long time.i have taken xplain plan report for selecting the row which i am going to delete.Below is report.kindly guide me what need to be done further.
SQL> select * from table (dbms_xplan.display);
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------
Plan hash value: 4292193024
---------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 9 | 105M (4)|352:21:59 |
| 1 | SORT AGGREGATE | | 1 | 9 | | |
|* 2 | FILTER | | | | | |
|* 3 | TABLE ACCESS FULL | ANR_ORDER_ERRORS | 638K| 5613K| 10647 (2)| 00:02:08 |
|* 4 | VIEW | index$_join$_002 | 1 | 9 | 174 (4)| 00:00:03 |
|* 5 | HASH JOIN | | | | | |
|* 6 | INDEX RANGE SCAN | COR_IDX1 | 1 | 9 | 180 (4)| 00:00:03 |
|* 7 | INDEX FAST FULL SCAN| COR_PK | 1 | 9 | 87 (3)| 00:00:02 |
---------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter( NOT EXISTS (SELECT /*+ */ 0 FROM (SELECT "ORBIT_NO"
"ORBIT_NO","MARKET" "MARKET",ROWID "ROWID" FROM "OCC_CON_ORDERS"
"indexjoin$_alias$_002","OCC_CON_ORDERS" "indexjoin$_alias$_001" WHERE "MARKET"='UB'
AND ROWID=ROWID AND LNNVL("ORBIT_NO"<>:B1)) "OCC_CON_ORDERS" WHERE "MARKET"='UB'))
3 - filter("MARKET"='UB')
4 - filter("MARKET"='UB')
5 - access(ROWID=ROWID)
6 - access("MARKET"='UB')
7 - filter(LNNVL("ORBIT_NO"<>:B1))
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
