topic Re: check for select * in abap code in Application Development and Automation Discussions

check for select * in abap code

Former Member — Tue, 08 Jun 2010 20:15:58 GMT

Hi ,

Ii try to personalize a check in order to check for SELECT * statement , i want to create new check in code inspector , can i have some advices .

best regards .

Re: check for select * in abap code

Former Member — Wed, 09 Jun 2010 07:23:26 GMT

I would not recommend to do that, it is a waste of time. There are lots of SELECT * which are simply correct. There are a lot of SELECT * where not all fields are needed, but the width is so small that you can not expect to save anything.

Instead of wasting your time, concentrate on the checks which are there:

Code Inspectoru2019s Performance Checks (I)

/people/randolf.eilenberger/blog/2007/03/12/code-inspector146s-performance-checks-i

Code Inspectoru2019s Performance Checks (II)

/people/randolf.eilenberger/blog/2007/07/02/code-inspector146s-performance-checks-ii

there is also a number III.

These checks are on missing indices, problems with buffer usage and inefficient usage of internal table. They work

fine, (I know who programmed them and fine the top issues for performance.

Siegfried

Re: check for select * in abap code

Former Member — Wed, 09 Jun 2010 07:23:56 GMT

deleted duplicate

Re: check for select * in abap code

Former Member — Wed, 09 Jun 2010 08:31:15 GMT

Thinks for the answer , i Will studies the others check .