Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18436 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudheer
INSERT BECAUSE IN DELETE STATEMENT TO TAKE THE TIME TO DELETE BECAUSE THAT DATA WHERE IT HAVING TO IT SERACH.BUT INSERT NOT LIKE THAT WHEN U WRITE THE COMMAND ITS NOT TO TAKE LONGER TIME...........
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram bhajan tiwari
Delete
Because during delete statement pointer has no need to
find the address of memory but in insert statement the
pointer has first point the memory then it can insert so it
will take more time than delete.
| Is This Answer Correct ? | 0 Yes | 1 No |
How can we force the database to use the user specified rollback segment?
What are the different editions of oracle?
Can we write insert statement in function in oracle?
Explain the use of online redo log files in oracle.
Explain self joins in oracle?
What are the common oracle dba tasks?
Differentiate between function and procedure in oracle.
What are the set operators union, union all, minus & intersect meant to do?
which clause we are not used in where clause?
Give the various exception types.
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
How to revoke create session privilege from a user in oracle?
Oracle General 
