Hammer drill is primarily used for creating holes in hard materials like concrete, brick, and stone. It achieves this by combining a rotary motion with a hammering action, allowing it to break up the material and penetrate harder surfaces that a regular drill cannot.