Noise really hurts detailed work. With a little noise software engineers find fewer bugs, productivity drops, & many tasks are disrupted.
But moderate noise may help creativity by disrupting your thinking! It makes it harder to think, but that may actually prompt new ideas.
A lot of people are asking about music. The results there are not 100% clear, but recent studies have found a negative impact on complex and creative tasks.
No difference if the was instrumental, foreign language, or a particular genre. Silence or low-level noise was best.