Viewing 3 posts - 1 through 3 (of 3 total)
Alan.B (3/19/2013)
March 20, 2013 at 12:26 pm
#1599070
Thanks Alan.B for testing it extensively! 🙂
When I ran your queries, like:
select n.*
from Names n
FULL JOIN TableB b ON n._id=b._id
WHERE LEFT(name,1)='A'
AND ChildCount>50
it showed Nested Loop as you suggested.
But, I ran...
March 19, 2013 at 1:00 pm
#1598611
My question is the latter one - which is more efficient.
March 19, 2013 at 12:03 pm
#1598584