Skip to Content
0
Former Member
Jun 02, 2008 at 12:00 PM

Performance

18 Views

Hi,

the select statement was extracting the fields from View and one more table with join statement: like shown below:

FROM ( view AS p

INNER JOIN plko AS k ON pplnty EQ kplnty

AND pplnnr EQ kplnnr

AND pplnal EQ kplnal )

LEFT JOIN crhd AS c ON parbid = cobjid

Because of too many joins and the table being view there is a performance issue:

Is there anyway that i can increase the performance ?

Raj