Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18776 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep desai
Its definitely Delete.
Becuase
When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the
new values into Datablocks.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sanal kumar
Delete runs faster than insert
coz whle during delete command,it only removes the records
from the table and the space alocated for the records
remains still..but for insertion,need to allocate the space
and insert the records in data blocks..
| Is This Answer Correct ? | 5 Yes | 1 No |
How do I spool in oracle?
Tell me New Feature of Oracle 10g?
Give syntax for SQL and ORACLE joins.
How to get last row id?
What are the system predefined user roles?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
can u call user defined functions in select statements
What do you understand by database schema and what does it hold?
How do we get field details of a table?
What is Trigger in Oracle?
What is the difference between Sleep and Wait? (Java)
Oracle General 
