Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18555 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 |
What is a Garbage Collection? and what is full recursive Garbage collection?
How to call a sub procedure?
How can you merge two tables in oracle?
what is the syntax of update command?
How to change system global area (sga) in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
what are pseudocolumns?
What are the types of synonyms?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
How to invoke the data pump import utility?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
Oracle General 
