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

TO IMPROVE MY PERFORMANCE

SELECT SINGLE * FROM T001W WHERE WERKS = PLANT.

I M USING THIS SELECT STMT. IS THERE ANY OTHER FORMAT SO THAT I WILL IMPROVE MY PERFORMANCE

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 09:03 AM

    Hi,

    the query which you are using doesnot need any improvement . but put more than one field in where condition based on the situation the query is used. this can improve performance .

    SELECT SINGLE * FROM T001W WHERE WERKS = PLANT and key = xxxx ...........etc

    Hope this is clear.

    thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Murthy,

      Congratulations! That's an excellent example for hunting points based on an incorrect answer.

      Please continue this way..... It's disturbing the Forum-Philosophy. I can name you a couple of other members you should join immediately.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 08:59 AM

    Hi,

    The is the best query u cant write. this is definitely not going to cause any problem.

    • pls avoid CAPITALs when posting a question

    regards,

    madhu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 08:59 AM

    Go and sign-up at a gym if you want to improve your performance.

    Stop writing in upper case already.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 09:02 AM

    Hi there.

    Since you are selecting using the primary key, your select single is the fastest way to get your data.

    However, if you don't need all the data of T001W, you can always replace your select * by a select field1 field2 ... fieldn ...

    Regards.

    Valter Oliveira.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 11:20 AM

    Txxxx-table should never appear in your SQL trace. These tables are buffered and should come from the buffer and are therefore not in the SQL trace.

    The last recommendation, for which you gave 10 points, is therefore incorrect. If you add something to the WHERE condition besides WERKS, then you will bypass the technical table buffer, as the buffer setting is generica, and you will make the statement much worse!

    The last recommendation is usually o.k., but not here.

    Actually not, a SELECT SINGLE is optimal if you specify the full key, and there is no 'more optimal' possible. So last recommendation is always wrong.

    Siegfried

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 11:22 AM

    duplicate

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yep, Siegfried is right (and that's what I said). The only way to improve your select is to resctrict and get only some fields instead of using select *.

      Murphy is wrong. But you give 10 points to the one you want!

      Regards,

      Valter Oliveira.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 01:17 PM

    Check your junk mail box. You'll find lots of help to improve your performance.

    Rob

    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.