which statement is running fastly ie insert or delete?
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of file param in imp command?
what is IDE,DMV in sql server?
How to apply filtering criteria at group level in oracle?
How to load data through external tables?
How to initialize variables with default values?
How to pass a cursor variable to a procedure?
What happens to indexes if you drop a table?
What is BBED in Oracle?
Explain the use of grant option in imp command.
How to assign values to variables?
What is Redo Log Buffer in Oracle?
what is the scripts in data base?
Explain the use of file option in exp command.
What are joins, explain all types of joins?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.