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

Join conditions

Hi ,

i have a small questions.

will join conditions in sql queries affect perfomance? how? give with an example

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 22, 2007 at 10:42 AM

    Hi Vasanth,

    You may have said the answer. But how will you know when you are writing a report whether it has large or small amount of data while writing a program for implementation Project. We will not all have any data for checking the performance. Ok . tell me something other than this if you know.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2007 at 01:47 PM

    hi,

    deffinetly it will affects the perfomace.

    <b>it will improves the perfomance when using view insted of using multiple select statements.

    When multiple SAP tables are logically joined, it is always advisable to use inner join to read the data from them. This certainly reduces the load on the network.</b>

    but we can improve the perfomance by using FOR ALL ENTRIES insted of using VIEWS .

    regards,

    Ashokreddy.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2007 at 02:12 PM

    HI

    Join will definetly affect ur performance.. Instead of this use For all entries.

    Procedure.

    Select all fields from one table and put it into one internal table.

    then select fields from 2nd table using for all entries and put into another table.

    This will reduce ur performance.

    Reward me if its useful

    Regards

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2007 at 01:40 PM

    Hi,

    Look at the below link, you will get the correct information

    http://blogs.ittoolbox.com/sap/db2/archives/for-all-entries-vs-db2-join-8912

    Regards

    Sudheer

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2007 at 01:41 PM

    hi raju,

    <b>join's</b> will affect the performance,

    instead of this u can use <b>for all entries</b>.

    reward points if helpful,

    regards,

    seshu.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2007 at 01:43 PM

    Hello,

    <b>

    Join  -  Used when the data in the table is less.
    
    For all entries - Used when the data in the table is huge.

    </b>

    So use like this.

    Vasanth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2007 at 01:48 PM

    check this:

    <a href="/people/rob.burbank/blog/2007/03/19/joins-vs-for-all-entries--which-performs-better">JOINS vs. FOR ALL ENTRIES - Which Performs Better?</a>

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 07:58 AM

    answered

    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.