Alan, I hope you can elaborate a little on what you have written in regards to S/N ratio, as the topic of some of these Canon lenses comes up frequently on various FB groups I belong to. I get that the larger front element let's in more light - and that is good - but how does one explain the practical advantage of that when the f stop (of the 200-800, in this case) is slower? Is it simple math ( highly unlikely?) that the 89mm entrance pupil lets in 27% more light (89/70)? If so, does that translate (all else being equal) to a 27% reduction in noise with the 200-800 at f/9 compared to the 100-500 at f/7.1? Or something totally different?
Here's the maths/physics behind why it is the diameter, d, of the lens (strictly the entrance pupil) that is important for signal/noise rather than the f-number, which I'll call N. For a subject that is some distance away, the size of the image (height or width) is directly proportional to the focal length f. (Double the focal length and you double the width and height).
The brightness of the image will depend on the amount of light getting through the lens, which will be proportional to its area, ie d^2 (=0.25*pi*d^2) and it will be dispersed over an area that is proportional to the height x width of the image, ie f^2. So, the brightness of the image varies as:
d^2/f^2.
f-number N = f/d, so the brightness varies as (1/N^2),
which is something nearly every photographer knows that the brightness drops by a factor of 2 when the f-number gets larger by 1.4x (the square root of 2). So, the f-number is what is used in the exposure triangle. 1/N is a measure of the number of photons hitting per unit area of the image per unit of time.
Signal/noise in low light is proportional to the square root of the
total number of photons hitting the whole image per unit time. The total number of photons is proportional to the area of the image x d^2/f^2
No. of photons varies as f^2 x d^2/f^2, ie varies as d^2.
So the S/N varies as d.
Importantly, it's not the iso that causes the noise, it's the low number of photons that usually accompanies the high iso that contains the noise. An image with a high iso but containing a higher number of photons because the image is large can be less noisy than a much smaller image with a lower iso, as we should know from an iPhone vs an APS-C vs FF vs MF.