Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18956 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep desai
Its definitely Delete.
Becuase
When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the
new values into Datablocks.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sanal kumar
Delete runs faster than insert
coz whle during delete command,it only removes the records
from the table and the space alocated for the records
remains still..but for insertion,need to allocate the space
and insert the records in data blocks..
| Is This Answer Correct ? | 5 Yes | 1 No |
What is the minimum client footprint required to connect c# to an oracle database?
what are the advantages of running a database in NO archive log mode?
How to call a stored function with parameters?
How to connect to a local oracle 10g xe server?
How to assign values to data fields in record variables?
What is oracle join syntax?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
how to make an oracle object
interview questions with answer for cts
How to change user password in oracle?
what is difference between cartesian join & cross join even they give same result?
What is ASM (Automatic Storage Management) in Oracle?
Oracle General 
