which statement is running fastly ie insert or delete?
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 |
Explain the difference between a procedure and a function? What do you understand by those terms?
Is there a function to split a string in plsql?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
What is the difference between sharding and partitioning?
How to test null values?
How do I recompile a procedure in oracle?
What is recycle bin in Oracle?
Explain what are the different type of segments?
Define Transaction ?
How to do paging with oracle?
What is the maximum limit on the number of columns in a table?
What is a Temporary Segment ?