Subquery or Join

Subquery or Join

rtenny
Member
Posts: 134
Threads: 2
Joined: Jun 2016
Reputation: 3

09-27-2017, 08:42 AM

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.

On the package it said needs Windows 7 or better. So I installed Linux.

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