Once you achieve the minimum octane required by an engine to suppress detonation at the correct timing - any additional octane is wasted and only slows you down.

If you have to run retarded timing with the fuel you are currently using, then increasing the octane would allow you to increase the timing and that would give you more power. The key is you need to know what you engine's ideal timing is.