Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQVI tables etc

Go to solution
Former Member

‎04-10-2008 7:34 PM

0 Kudos

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.

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎04-10-2008 7:50 PM

0 Kudos

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.

1 REPLY 1

Go to solution
Former Member

‎04-10-2008 7:50 PM

0 Kudos

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.