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