• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Subquery or Join

#2
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.
Reply


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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.