Actually, i dont think there are (m)any pieces that DONT require a combination of tension and relaxation
Not quite so simple. Any movement must be smoothed by the antagonist otherwise the movement is just a jerk.
I've measured the antagonist when flexing the fingers using SEMG - there's always substantial activity. Think about it - the more active your flexion the more active the extensors need to be to smooth the action. All best left up to the specialists I can't help thinking.
I mean is there any pieces that should be played with tension and better sound ffect.Eg,relaxation for fast pieces and tension for slower pieces , forte ,etc
Nobody gets it wrong because they didn't know about the folly of severe cocontractions and nobody cures them by knowing that they are bad. Whether you succeed or fail, the brain is not wired that way. Totally separate processes determine whether it goes wrong this way. You don't need to know a thing about cocontractions to get it right and you equally can know everything about them yet be appallingly tense. The answers lie in what actions make them necessary/unnecessary.
The secret to a really good technique seems to be to:1) activate what you need and keep it activated;2) "relax" what you don't need and keep it "relaxed" (= not more tonus in the muscles than is absolutely required).
I also notice that unnecessary tension easily creeps in unnoticed.
I have heard that there are teachers who insist on the opposite. They start with full relaxation, and slowly add motion, stopping and correcting every time tension sneaks in. I have not had any experience with that approach, and I'm probably describing it poorly as a result.