How long should one “hold” an investment

Is Gold a good investment option.