power - SMD capacitor package size and high frequency performance

I am designing a circuit with a Spartan6 FPGA and the documentation for the FPGA specifies 4.7uF (0805) and 0.47uF (0402) capacitors for decoupling. As I really do not want to solder 0402 capacitors if I can avoid that, I would like to use 0805 or 1210 size capacitors for this. Would their performance at high frequencies be different from those that have smaller packages?

The max in/out frequency is ~300MHz

Answer

Yes, it makes a difference.

A larger package will generally have a higher parasitic inductance, leading to a lower self-resonant frequency and higher impedance at high frequencies:

(image source: electronicdesign.com)

For an 0.1 uF capacitor at 0402 size, the resonant frequency is typically in the 10-20 MHz range.