Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18971 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 can I see all tables in oracle?
What is the data pump export utility?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain an integrity constrains?
When do you get a .pll extension in oracle?
How can you merge two tables in oracle?
What is connection pooling in oracle?
Can we store images in oracle database?
What is user managed backup in Oracle?
How to revoke create session privilege from a user in oracle?
How to rename an existing table?
Please explain joins in oracle?
What is a directory object?
Explain oracle’s system global area (sga).
Can you tell me how to add new column in existing views?how?How is possible?
