I have a SELECT statement as follows:
SELECT aguid_hi bpartner_no
FROM crmd_link AS a
INNER JOIN crmd_partner AS b ON bguid EQ aguid_set
INTO TABLE p_partners
FOR ALL ENTRIES IN i_sub_contracts
WHERE a~guid_hi EQ i_sub_contracts-guid
AND a~objtype_hi EQ '05'
AND b~partner_fct EQ p_partner_fct.
Please tell me if I can create a view for the above.
Once I create a view for the above will it really boost the performance.
Kindly reply immediately as this is bit urgent.