Which one is better performance wise?

[Former Member]

Which one is better performance wise?

For all entries or inner join?

update or modify databaase table?

Regards

Abhilash.

[Former Member]

For all entries or inner join? - ALL ENTRIES is performnace wise better as it selects the data from DB in one shot

Update or modify databaase table? - both are almost equal...is case of MODIFY if the key exists in table it automatically goes for INSERT statement

[Former Member]

/people/rob.burbank/blog/2007/03/19/joins-vs-for-all-entries--which-performs-better

http://blogs.ittoolbox.com/sap/db2/archives/for-all-entries-vs-db2-join-8912

[Former Member]

Hi,

ALL ENTRIES gives better performance compater to innerjoin.

Let me know if u have further query.

thanks

Kinjal

[former_member156446]

<repeat of the same answer by venkat appikonda > original content removed by moderator.

Edited by: Durairaj Athavan Raja on Jun 22, 2008 10:27 AM

[Former Member]

Hi,

Which one is better performance wise?

For all entries or inner join?

A. for all entrie is the better option, But if you are joining 2 tables then it will not effect in your performance issue but if you join more than 2 tables then performace peroblem comes into picture.

update or modify databaase table?

Hey both are same but when you are updating or modifing your DB table then you have to write COMMIT WORK after update and modify other wise some times it will update in you database table but some times it wont.

Please reward points if it helps

Thanks

Vikranth

[Former Member]

Hi Vikranth,

Thnks for the update.

Regards.

Abhilash.