question on joins and keep

[d_koti24]

Hi Guys,

            i know the diff b/n join and keep,but my question is in which situation we go for join,and in which situation we for keep?

Regards,

koti

[Gysbert_Wassenaar]

If you need to do calculations or comparisons in the script using fields from different tables then you'll first have to join the tables. In other cases you are free to decide if you'd rather have separate tables and use the keep function or want to consolidate tables using joins. There can be a difference in performance. That's something you'll have to test yourself since it depends very much on your specific data.

[its_anandrjs]

Hi,

There are many reasons for using JOINs and KEEP depends on the user requirement.

1. Suppose you have two tables and this are big table and associated with key field but if you create single table it load once and give performance also.

2. Second there is one

table1: EmpNo,Salary and

table2: EmpNo, Commision, Address

but user wants EmpNo,Salary,Salary+Commision.

On chart it is ok to perform but if he needs to do some more calculation like top and bottom once then if it is in single table will be better.

It depends how it is used

Regards

Anand