which statement is running fastly ie insert or delete?
- 13 Answers
- 15400 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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to connect to the server with user account: sys?
What is transaction control statement and how many types of transaction control statement in Oracle?
Explain oracle 12c new features for developers?
What is oracle used for?
What is the simplest tool to run commands on oracle servers?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Differentiate between translate and replace?
What is the quickest way to export a table to a flat file?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain the dml?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to write date and time literals in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
