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

SQVI tables etc

Can you please tell me and this might sound stupid that the table positioning in SQVI affects the query? I mean if there are two tables and I place them farther apart that will affect the query in contrast to the fact that they were placed closer. The joins are logical so it should'nt be an issue.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 06:50 PM

    Hey Saad,

    It does not effect if you place the tables far apart one another. It does effect the order of the table take the condition you have 3 tables and in the order 1 2 3 and if you change the order to 2 3 1 or 3 2 1 out put would be effected by this not only that type of join conditon also effect the final output like normal join or outer join that makes also makes lot of difference.

    If you need any further info let me know.

    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.