Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 19371 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
How to connect asp pages to oracle servers?
Explain an index segment?
What are the restrictions in a oracle read only transaction?
What is the difference between PFILE and SPFILE in Oracle?
What are the logical operations?
What is bulk collect in oracle?
What are internal user account in oracle?
How to convert characters to times in oracle?
What is system global area (sga) in oracle?
How to convert csv to table in oracle?
How to check the oracle tns settings?
How to handle a single quote in oracle sql?
Please explain joins in oracle?
State and explain the different types of data models?
What is hot backup and logical backup?
