Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Perfomance issue : inner join on buffered db dable

0 Kudos

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

4 REPLIES 4

former_member188685
Active Contributor
0 Kudos

try to use for all entries instead of joins...

regards

vijay

0 Kudos

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.

0 Kudos
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>

0 Kudos

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