| Performance deleting rows [message #176282] |
Wed, 07 June 2006 12:25  |
Nau
Messages: 24
Registered: October 2004
|
Junior Member |
|
|
Hi,
I'm looking for a way of deleting rows quicker than the delete dml sentence.
I know truncate sentences, but i don't want to truncate a table or a partition, I want to delete a great number of rows (identified by a where clause), but not a whole partition or table.
For example, inserting rows i can use insert sentences or i can use sql-loader, żis there something similar deleting rows??
My problem is deleting time.
Any advice will be greatly apreciatted. Thanks in advance
Juan
|
|
|
|
| Re: Performance deleting rows [message #176283 is a reply to message #176282] |
Wed, 07 June 2006 12:43  |
jrich
Messages: 35
Registered: February 2006
|
Member |
|
|
If you are deleting a large % of a table, you might consider copying the rows you want to keep to a new table using CTAS, then doing renames to replace the old table with the new. This can be a little tricky if foreign key constraints are involved, but it is definitely a time saver in some situations.
JR
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
