Home » SQL & PL/SQL » SQL & PL/SQL » Faster deletion (Oracle 10 g)
Faster deletion [message #354591] Mon, 20 October 2008 08:27 Go to next message
sudheer0886
Messages: 7
Registered: September 2008
Junior Member
Could anyone please assist with better solution which does the FASTER DELETE .We are not worried about the DELETED data , and in any case we will not rollback the data.

Is there any way for setting the database to achieve 'FASTER DELETES'. If so please provide a solution
Re: Faster deletion [message #354594 is a reply to message #354591] Mon, 20 October 2008 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you already search about this FAQ?

Regards
Michel
Re: Faster deletion [message #354597 is a reply to message #354591] Mon, 20 October 2008 08:59 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In what this topic is different of your 2 previous ones:
- Deleting large number of rows Quickly in Oracle Db
- How to delete records without generating redo logs
And tell us what do you expect more?

Regards
Michel
Previous Topic: how to list selected field in whole database
Next Topic: String comparison
Goto Forum:
  


Current Time: Mon Dec 05 18:55:59 CST 2016

Total time taken to generate the page: 0.11194 seconds