which statement is running fastly ie insert or delete?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / kandulasreekanth

13 Answers
18435 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which statement is running fastly ie insert or delete?..

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

which statement is running fastly ie insert or delete?..

Answer / amit choubey

insert

Is This Answer Correct ?

13 Yes

7 No

which statement is running fastly ie insert or delete?..

Answer / somya

delete

Is This Answer Correct ?

7 Yes

1 No

which statement is running fastly ie insert or delete?..

Answer / sandep

it is delete

Is This Answer Correct ?

6 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / bhavna

Delete

Is This Answer Correct ?

5 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / chandiran

Delete

Is This Answer Correct ?

5 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / swati gupta

it is delete...........

Is This Answer Correct ?

4 Yes

0 No

which statement is running fastly ie insert or delete?..

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

which statement is running fastly ie insert or delete?..

Answer / vivek kumar dixit

delete runs fastly

Is This Answer Correct ?

3 Yes

0 No

which statement is running fastly ie insert or delete?..

Answer / akhilesh

Delete

Is This Answer Correct ?

2 Yes

0 No

Post New Answer