which statement is running fastly ie insert or delete?
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
How index is implemented in oracle database?
Use of an integrity constraint is better to validate data. Explain
What is columnar storage what is the advantage?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Explain the use of Merge statement in oracle 11g
Explain view?
How to use subqueries with the in operator using oracle?
Explain the use of constraints option in exp command.
What happens to the indexes if a table is recovered?
Is oracle a language?
Explain an exception and its types?
What is the usage of save points in oracle database?
How many types of auditing in Oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is an oracle function?