If you give someone a Bitcoin address to receive a payment, how much can they find out about your other transactions?

I understand they can look up that address. What I’m not sure about is whether they can also connect it to other addresses in the same wallet.

Does using a fresh address each time keep those payments separate, or can spending them together later link them again?

A simple example would help. Trying to understand what a new receiving address actually does for privacy.