topic Re: performance error for select single * statement in Application Development and Automation Discussions

performance error for select single * statement

Former Member — Fri, 30 Nov 2012 06:15:44 GMT

Sir,

SELECT SINGLE * FROM zqcs INTO wa_zqcs WHERE coll_no = pr_coll.

on this particular statement i am getting the performance error in the code inspector of one program.

any aletrnative statement can be written to reslove this issue.

Thanks & Regards.ng

Moderator message : Not enough re-search before posting, discussion locked

Message was edited by: Vinod Kumar

vinoth_aruldass — Fri, 30 Nov 2012 06:22:57 GMT

hi satish,

Make sure that the above statement is not used inside the loop.

if you are using inside the loop it will be performance error.

the alternate is select * from zqcs into table it_zqcs where coll_no = pr_coll.

then you can use

read table it_zqcs into wa_zqcs index 1.

Regards,

Vinoth