The single elimination tournament is best type when you have a large number of teams and a short time frame.
When a team wins they continue, and when they lose they're out.
The Double Elimination tournament is the best type of tournament to run if you have a long enough time frame to complete all of the games - there are more games involved in Double elimination versus single elimination tournaments.