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 to bring a tablespace online?
Explain the function of optimizer in oracle?
Explain the use of log option in exp command.
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How can we view last record added to a table?
How to rebuild an index in oracle?
How do I manually uninstall oracle client?
Is oracle a language?
What is oracle latest version?
What happens if the imported table already exists?
What is a package in oracle?
How to add another datafile to a tablespace?
What is meant by raw datatype?
What is a system tablespace and when it is created?
What is a data lock in oracle?