Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 19007 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 to handle exceptions in post production
What is DTS and purpose of DTS ?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
What is the usage of merge statement?
What are the type of Synonyms?
What privilege is needed for a user to query tables in another schema?
Explain do view contain data?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
"primary key=unique+null" is equal,reson?not,reason?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How do we display rows from the table without duplicates?
What are the limitations oracle database 10g xe?
Oracle General 
