Can someone explian me why this delete statement is very slow ?? any suggestions !!! pl find the details below !!
Thanks Madhu Statement: ++++++++ delete from <tabke_name> where eow_date<ADD_MONTHS(TO_DATE(:b0,'YYYYMMDD'),((-1)* :b1)); PLAN: +++++ Plan Table -------------------------------------------------------------------------------- | Operation | Name | Rows | Bytes| Cost | Pstart| Pstop | -------------------------------------------------------------------------------- | DELETE STATEMENT | | 1M| 20M| 66106 | | | | DELETE |WIN_STORE | | | | | | | TABLE ACCESS BY GLOBAL I|WIN_STORE | 1M| 20M| 66106 | ROWID | ROW L | | INDEX RANGE SCAN |WIN_STORE | 1M| | 2616 | | | -------------------------------------------------------------------------------- Session_IO: +++++++++ 11:27:49 SQL> @session_top_sql OS User DB User SID # of UndoBlk LOG IO PHY IO HASH VALUE SQL ADDRESS ------------------------------ ------------------------------ ---- ------------ ---------- ---------- ---------- ---------------- batchusr RTKBATCH 77 52349 6223101 987505 1253119663 C0000000BB3BC2B8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
