‎2010 Jun 08 9:15 PM
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 .
‎2010 Jun 09 8:23 AM
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
‎2010 Jun 09 8:23 AM
‎2010 Jun 09 9:31 AM
Thinks for the answer , i Will studies the others check .