topic Re: Which one is better performance wise? in Application Development and Automation Discussions

Which one is better performance wise?

Former Member — Sat, 21 Jun 2008 13:42:05 GMT

Which one is better performance wise?

For all entries or inner join?

update or modify databaase table?

Regards

Abhilash.

Re: Which one is better performance wise?

Former Member — Sat, 21 Jun 2008 13:48:45 GMT

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

Re: Which one is better performance wise?

Former Member — Sat, 21 Jun 2008 15:12:46 GMT

/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

Re: Which one is better performance wise?

Former Member — Sat, 21 Jun 2008 18:55:00 GMT

Hi,

ALL ENTRIES gives better performance compater to innerjoin.

Let me know if u have further query.

thanks

Kinjal

Re: Which one is better performance wise?

former_member156446 — Sat, 21 Jun 2008 19:51:02 GMT

<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

Re: Which one is better performance wise?

Former Member — Sun, 22 Jun 2008 07:38:04 GMT

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

Re: Which one is better performance wise?

Former Member — Sun, 22 Jun 2008 07:55:01 GMT

Hi Vikranth,

Thnks for the update.

Regards.

Abhilash.