I am oberving slightly better response if I am using a high frequency 18Ghz sma cable with bnc adapters. Earlier I was using a lower frequency generic bnc cable.
Welcome to Probe Loading 101!
You mention a 'current' through a 100R resistor, but you don't mention the source impedance or amplitude of your signal. If your source is 50R, then ~100pF at 10MHz is going to be noticeable, if it is truly a current source (high impedance) then it will be worse. The effect you are seeing is entirely due to the combined capacitance of the scope and the BNC cable. Making the cable smaller or shorter may reduce this a bit but it is not an appropriate way of dealing with this situtation. The usual method would be to use a properly compensated x10 probe with an input capacitance low enough to not cause significant errors over your bandwidth range. 8-12pF is a common, easily acheivable number for a regular x10 probe and that would give you a pretty small error at 10MHz.
Transmission line effects are not important here. 10MHz has a wavelength of ~30 meters in free space and ~20 meters in cable, so for a cable of 2 meters or less you can pretty much ignore the subject entirely.