12-16-2005 8:16 AM
I have done a inner join between 2 tables . one of the table is fully buffered.
i get a performance error
"(H) SELECT on buffered table in a JOIN"
kindly help
12-16-2005 8:21 AM
12-16-2005 8:30 AM
This is the code
SELECT * INTO CORRESPONDING FIELDS OF TABLE lt_obj_links
FROM rpm_obj_link AS p INNER JOIN rpm_obl_obtyp AS f
ON fobject_type = pobject_type
WHERE p~project_guid = lv_item_guid
AND f~application = i_application
AND f~logsys = i_system.
where rpm_obl_obtyp is a buffered table.
I cannot use for all entries because it give a syntax error.
12-16-2005 8:42 AM
SELECT *
INTO CORRESPONDING FIELDS OF TABLE lt_obj_links <b>BYPASSING BUFFER</b>
FROM rpm_obj_link AS p
INNER JOIN
rpm_obl_obtyp AS f
ON f~object_type = p~object_type
WHERE p~project_guid = lv_item_guid
AND f~application = i_application
AND f~logsys = i_system.
and one more suggestion if you are using into corresponding why can't you select the requirefields rather than selecting all fields..
and specify <b>into table</b>
12-16-2005 8:58 AM
I checked the code by using the BYPASSING BUFFER,
But on object check on the task request . i still get the warning. But found a way out by adding a comment .
Thanks a lot