Hi,
I have an issue with the performnace of the extractor:
Extractor is a generic one with FM in its definition
The reason i found was logic in the FM:
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 ? now it s taking more than 6 hours for the purpose!
Raj