[PERFORM] subquery vs join on 7.4.5

Hi - This is based on a discussion I was having with neilc on IRC. He suggested I post it here. Sorry for the length - I'm including everything he requested I'm comparing the speeds of the following two queries on 7.4.5. I was curious why query 1 was faster than query 2: query 1: Select

[PERFORM] join vs. subquery

Hi - This is based on a discussion I was having with neilc on IRC. He suggested I post it here. Sorry for the length - I'm including everything he requested. I'm comparing the speeds of the following two queries. I was curious why query 1 was faster than query 2: query 1: Select layer_nu