It only works in OpenGL games and only when VSync is on. It might enable higher framerates than your screen refresh rate if both of those criteria are satisfied.
@OP
It works in both kind of games, you can read it's definition and function from the article provided, also make sure to know how to force it in most situation.