Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18573 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 to create a temporary table in oracle?
What are ACID properties in databases?
How to create lov dynamically at runtime & attach to text field?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
Does oracle partitioning improve performance?
What are the advantages of Views ?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
write a query that displays every Friday in a year with date?
Explain joins in oracle?
 What are the oracle DML commands possible through an update strategy?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the difference between truncate & delete command?
Oracle General 
