Rubbing compound for scratches?

Does the compound really work to eliminate scratches from the paint job of a car? I bought some and applied it, the scratch disappeared! But how long will this last? If it gets wet, would the scratch reappear?