Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18779 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 oracle update statement with inner join ?
What is difference between cartesian join and cross join?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
how to handle exceptions in post production
what is foreign key?
How to delete multiple rows from a table in oracle?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How to work with data objects interactively?
What is a oracle database?
How to start an oracle instance?
What is meant by joins? List out the types of joins.
Oracle General 
