Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18989 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 recommended interval at which to run statspack snapshots, and why?
How to do paging with oracle?
What are the uses of a database trigger?
What is difference between truncate and delete?
What are the attributes of cursor?
How to connect to oracle using service name instead of sid?
What is the difference between hot backup and cold backup in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to list all indexes in your schema?
How to delete a user account in oracle?
How to create a new view in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is an oracle user account?
What is a tns file?
How to define a variable of a specific record type?
