Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 19348 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 |
What is an oracle database table?
Draw E-R diagram for many to many relationship ?
How to best split csv strings in oracle 9i?
Can we save images in a database and if yes, how?
What does sharding mean?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
What is index-organized table in Oracle?
What is snapshot is too old? Give and example for better understand.
When do we use group by clause in a sql query?
How to change user password in oracle?
how to see the data (in unix) using dataset in datastage?
What is an Extent ?
Oracle General 
