topic hi experts in Application Development and Automation Discussions

hi experts

Former Member — Thu, 26 Apr 2007 05:18:00 GMT

hi gurus.

actually <b>for inner join condition , maximum how many tables we can use?</b>

regards .

subhasis

Re: hi experts

Former Member — Thu, 26 Apr 2007 05:23:06 GMT

hi,

there is no limit in no of tables any number of tables can bes used in an inner join condition.

regards,

Navneeth.K

Re: hi experts

Former Member — Thu, 26 Apr 2007 05:30:22 GMT

Hi Subhasis,

It is efficient for two or three tables only .

If it is more than three tables means Preformance points of view it will give the lower performance that why In case for inner join we will use the 'FOR ALL ENTERIES'.

if u use this performance is good. We have to follow the Performance standards.

Rgds,

P.Naganjana Reddy

Re: hi experts

Former Member — Fri, 27 Apr 2007 05:38:18 GMT

Hi subhasis,

In Joins concept,there is no limitation of tables that u can join..

but performance issue you can use 2 or 3 tables only.

why b.coz.. if u joined more 2 or 3 tables , performance will be reduced.

i thnk u get my point.

regards,

Vijay.