krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 24th, 2008

 

 The purpose of both the commands is different. Then how can you compare insert and delete performane?

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 4th, 2010

 

though theyare different things but still actualy what happens if we  are deleting any records  oracle have to search the values which we are deleting from the tablespaces,indexes etc. but while we are inserting any record oracle just place that record into the table name specified.

Rakesh

• Jul 22nd, 2011

 

Both insert and delete are used for different purposes. Also inserts are not always faster than delete. If the table has got indexes then insert will be slow and delete will be fast (if the WHERE clause uses the indexed column). If the table does not have any indexes then insert will be fast and delete will be slow

YASODHA

• Aug 29th, 2011

 

insert is faster than delete because insert just add values to the table. but delete want to store the deleted data in the memory for future references