Skip to Content
0
Former Member
Jun 02, 2008 at 09:54 AM

Performance issue: extractor:

20 Views

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