Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18443 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / sandeep desai
Its definitely Delete.
Becuase
When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the
new values into Datablocks.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
what is the difference between substr and instr function in oracle?
How can I introduce multiple conditions in like operator?
What is analyze command used for?
What is a schema in oracle?
How to define a data field as not null?
Explain the use of parfile option in exp command.
How to estimate disk space needed for an export job?
Can you tell me how to add new column in existing views?how?How is possible?
What is not equal to in oracle?
What happens in oracle commit?
How to assign a tablespace to a users in oracle?
What is primefaces used for?
How to create a new table in your schema?
Explain what are the type of synonyms?
Explain compound trigger in oracle?
