What are the best pipes for house plumbing?

You will see several types of pipes in the market and you will get confused after seeing this. Like which types of pipe are used for drainage, sewer, water supply and for all exterior fittings?