Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18785 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 are the predefined tablespaces in a database?
what is the difference between restoring and recovering?
What are the arithmetic operations?
How to rename an index in oracle?
What are the uses of synonyms?
What is a package ? What are the advantages of package ?
how to make an oracle object
what is IDE,DMV in sql server?
What is the usage of save points in oracle database?
Which is better Oracle or MS SQL? Why?
What happens in oracle commit?
How does oracle handle read consistency?
What is a sub query and what are the different types of subqueries?
How to create a single index for multiple columns?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
