Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18439 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
Does oracle partitioning improve performance?
How can we find out the current date and time in oracle?
What are the different types of failures that occur in Oracle database?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
11. Display the client number and name and the client number and name of the person who referred that client.
What is partitioned table in Oracle?
Briefly explain what is literal? Give an example where it can be used?
How to update values in a table in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Please explain drop constraint oracle?
What is a nvl function? How can it be used?
How can I introduce multiple conditions in like operator?
What is oracle open database communication (odbc)?
How to rename an existing table?
