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 |
What is the max number of columns in an oracle table?
What is the difference between $oracle_base and $oracle_home?
What is the difference between pre-select and pre-query?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
What is using clause and give example?
What is the difference between implicit index and explicit index?
What is the use of Redo Log Information ?
When system tablespace is created?
What the is the diff between local index and global index. give some example.
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What are the database administrators utilities available?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?