Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 19333 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How can we find out the duplicate values in an oracle table?
Write a syntax for update query in oracle?
What is the use of file param in imp command?
What is parameterized cursor in oracle?
master table and child table performances and comparisons in Oracle ?
Explain table?
How to do clean up if create database failed?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
what is IDE,DMV in sql server?
What is a partition in oracle?
What are the uses of Database Trigger ?
What are nested tables?
Which environment variables are absolutely critical in order to run the OUI?
