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


Please Help Members By Posting Answers For Below Questions

What is control file used for?

606


How to use windows user to connect to the server?

536


What is recycle bin in Oracle?

720


What privilege is needed for a user to create tables in oracle?

550


How to retrieve values from data fields in record variables?

572






What is a select query statement in oracle?

545


Can multiple columns be used in group by in oracle?

551


How will you differentiate between varchar & varchar2?

591


How to convert character types to numeric types?

578


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1738


What is translate in oracle?

623


How to start your 10g xe server?

596


What is program global area (pga) in oracle?

609


How to apply filtering criteria at group level in oracle?

587


What is a snapshot in oracle database?

583