Here's a look at the various drill bits from metal, wood, masonry and even specialised tiles ones.

Using the wrong bit is generally bad as it doesn't yield good result and can even damage expensive drill bits - such as when you're trying to drill masonry with a metal drill bit.