Now when the Atlon cpus first came out they used 100mhz ram and the cpu used the bandwith twice effectively making it 200mhz.
your CPU is connected to a chip called a NORTHBRIDGE through a bus called the FSB (front side bus). this chip also connects to the AGP port, and your system memory. the speed at which your RAM runs depends on the type. normal PC133 SDRAM runs at 133mhz. DDR SDRAM running at 133mhz (which is called PC2100) also runs at 133mhz, but provides what SDRAM would give if it was running at 266mhz.
With an Athlon running on a 100mhz fsb, the effective bandwidth that the fsb can handle is double what SDRAM running at 100mhz is capable of, so you typically aren't using the full bandwidth of the FSB (becuase the CPU normally interacts with the RAM, which is only capable of supplying the fsb with half it's full potential bandwidth, even though the SDRAM bus is running at full speed).
now, if you have DDR SDRAM running at 100mhz in the same situation, (this RAM is called PC1600) your RAM is finally capable of supplying the CPU with all the data that the fsb can handle, which means that the RAM is no longer nearly as big a bottleneck as before (the CPU would be sitting there waiting for data from the RAM alot more when not using DDR SDRAM).
that isn't to say that memory isn't a bottleneck or anything, it will always be too slow for CPU's to gain instantaneous access to it (whether the fsb is too slow, or the RAM itself is too slow), but every little bottleneck that is removed will provide a performance boost.