Left Join/Inner Join,which one should be considered better in terms of Performance

Question

Post reply

Left Join/Inner Join,which one should be considered better in terms of Performance

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

nageshp Right there with Babe Points: 719 More actions · Answer 1

Thanks Florian, Got it.Such strange cases need to be ignored.

tfifield SSCrazy Eights Points: 9655 More actions · Answer 2

nageshp,

This is not really a strange case at all. I've seen it sometimes where the left table will only have rows that correspond to the right table. This is just coincidence.

Consider a ProductCategory table and a Product table where the Product table has a category code in the ProductCategory table.. Sometimes there will be matching rows in the Product table for every ProductCategory. When someone adds a new ProductCategory there won't be a matching row in the Product table until someone adds a product with that category.

Todd Fifield