Is a Join Faster than two queries
I know this question has been asked before, 
[example](http://stackoverflow.com/questions/4758712/which-of-the-following-sql-queries-would-be-faster-a-join-on-two-tables-or-succe), and I do agree that one query with a join is faster than performing another query for each record returned by the firs query.

However, since with a join you tend to generate redundant field will this slow the network ?

Let's say I have a table hotel and HOTEL has a number of images in a table HOTEL_IMAGE. HOTEL has 20 fields. performing a join on HOTEL_IMAGE will produce 20 fields for each hotel image. will this query still be faster over the network ?
Is a Join Faster than two queries
===

I know this question has been asked before, 
[example](http://stackoverflow.com/questions/4758712/which-of-the-following-sql-queries-would-be-faster-a-join-on-two-tables-or-succe), and I do agree that one query with a join is faster than performing another query for each record returned by the firs query.

However, since with a join you tend to generate redundant field will this slow the network ?

Let's say I have a table hotel and HOTEL has a number of images in a table HOTEL_IMAGE. HOTEL has 20 fields. performing a join on HOTEL_IMAGE will produce 20 fields for each hotel image. will this query still be faster over the network ?