Home » SQL & PL/SQL » SQL & PL/SQL » How to optmise the SQL Statement to delete one lakh records ?
How to optmise the SQL Statement to delete one lakh records ? [message #321024] Sun, 18 May 2008 02:19 Go to next message
sv.venkat
Messages: 12
Registered: July 2006
Location: HYDERABAD
Junior Member
Hi Friends,
How to optmise the SQL Statement to delete one lakh records ?

Thanks in Advance.
Venkat.
Re: How to optmise the SQL Statement to delete one lakh records ? [message #321028 is a reply to message #321024] Sun, 18 May 2008 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just use DELETE.

Regards
Michel
Re: How to optmise the SQL Statement to delete one lakh records ? [message #321038 is a reply to message #321024] Sun, 18 May 2008 12:38 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

use rownum
Re: How to optmise the SQL Statement to delete one lakh records ? [message #321039 is a reply to message #321024] Sun, 18 May 2008 12:41 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>use rownum
WRONG!
Previous Topic: DBMS_OUTPUT.PUT_LINE & spaces
Next Topic: Converting an table of objects to ref cursor
Goto Forum:
  


Current Time: Thu Dec 08 00:03:37 CST 2016

Total time taken to generate the page: 0.13911 seconds