Perfomance issue : inner join on buffered db dable

[RavishShettyR]

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

[RavishShettyR]

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

[Former Member]

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

regards

vijay

[RavishShettyR]

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 f_{object_type = p}object_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.

[Former Member]

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>

[RavishShettyR]

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