Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18550 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 key preserved table?
How to commit the current transaction in oracle?
What is oracle database client?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Give the different types of rollback segments.
Explain the use of Merge statement in oracle 11g
How to view the tablespaces in the current database?
What do you mean by merge in oracle and how can we merge two tables?
How do I uninstall oracle client from windows?
What is the difference between sharding and replication?
What is the difference between view and materialized view in Oracle?
Explain oracle insert into command?
What is the usage of control file in oracle?
What is archive log in Oracle?
Design database draw er diagram for a certain scenario ?
