which statement is running fastly ie insert or delete?
- 13 Answers
- 16191 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
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How do I spool in oracle?
How to define a procedure inside another procedure?
What happens in oracle commit?
How to commit the current transaction in oracle?
How remove data files before opening a database?
What is an oracle?
How to count duplicated values in a column in oracle?
How to connect to a local oracle 10g xe server?
Why do you use stored procedures and state some of its disadvantages?
How to use existing values in update statements using oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to execute a stored procedure in oracle?
What is program global area (pga) in oracle?
What are the limitations of check constraint?
