Subquery or Join

Subquery or Join

omid_student
Omid Aghakhani
Posts: 381
Threads: 119
Joined: May 2015
Reputation: 0

09-27-2017, 08:48 AM

(09-27-2017, 08:42 AM)rtenny Wrote: I am not sure on this but i believe option is will be the faster one (if you have your index set correct)
The second one would create 2 selects and might not be able to use the index as efficiant.

But somebody with more DB knowledge might correct me on this.

Thanks

Messages In This Thread

Subquery or Join - by omid_student - 09-27-2017, 06:27 AM

RE: Subquery or Join - by rtenny - 09-27-2017, 08:42 AM

RE: Subquery or Join - by omid_student - 09-27-2017, 08:48 AM

RE: Subquery or Join - by dave friend - 09-27-2017, 01:48 PM

RE: Subquery or Join - by omid_student - 09-28-2017, 11:31 AM

RE: Subquery or Join - by dave friend - 09-28-2017, 12:11 PM

RE: Subquery or Join - by rtenny - 09-29-2017, 07:08 AM

RE: Subquery or Join - by ciadvantage - 09-29-2017, 08:05 AM

RE: Subquery or Join - by omid_student - 09-29-2017, 12:52 PM

RE: Subquery or Join - by php_rocs - 09-29-2017, 04:00 PM

RE: Subquery or Join - by omid_student - 09-30-2017, 11:19 AM