which statement is running fastly ie insert or delete?
- 13 Answers
- 16189 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 |
Explain the use of indexes option in exp command.
What is an oracle recycle bin?
Query to retrieve record for a many to many relationship ?
Explain the different normalization forms?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to commit the current transaction in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to retrieve the count of updated rows?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
How to use "in out" parameter properly?
what is data abstraction
What is oracle database 10g express edition?
Oracle General 
