Skip to Content
author's profile photo Former Member
Former Member

what can be used for replacing SELECT SINGLE * ?

What can be used for replacing SELECT SINGLE * for improving the performance in the following statements?

SELECT SINGLE * FROM REGUV

WHERE LAUFD = G_WLAUFD "RUN DATE ,SY-DATUM

AND LAUFI = P_LAUFI. "IDENTICATION NO

SELECT SINGLE * FROM T100

INTO CORRESPONDING FIELDS OF G_T100_WA

WHERE SPRSL = G_T_IALLMESS-MSGSPRA

AND ARBGB = G_T_IALLMESS-MSGID

AND MSGNR = G_T_IALLMESS-MSGNR.

SELECT SINGLE * FROM TBTCO

INTO CORRESPONDING FIELDS OF TBTCO

WHERE JOBNAME = FS_JOBNAME.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 07:09 AM

    U can try using select upto 1 rows.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 07:09 AM

    Hi shashank,

    Retreive only those fileds required by you and not all the fileds of the table , this will help to improve the performance a bit , but i dont think there is much scope to imporve the performance drasticly. Then the only other alternative is to try and provide the promary keys.

    Regadrs

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2007 at 07:12 AM

    Hi Shashank,

    You may try up to 1 rows instead of select single and also select fields that you require only, so replace * with fields that you want in your program.

    You just reply with your mail id i have good doc for performance tuning.

    Regards

    Ashutosh

    Reward points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 07:13 AM

    If you need all the fields and you know that only one record exists then u need to use select single * only. You can improve the performance by specifying key fields in the where clause of select statements. If the structure of the work area or internal table in which you are fetching the data is same as that of the database table then no need to use corresponding fields clause.

    Best Regards,

    Vibha

    *Please mark all the helpful answers

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.