Domain Name Servers.. When should they be changed?

When should the Name Servers for a domain be changed?
When the website changes host?
When the domain change registrar?
Both of the above? or Just one?
PS: If I buy a new domain from someone and forward it to my current website, what should the name servers be for that domain I just bought?

See original post by Sean101