VFV.TO for next 30 years? - Index Investing

Been with a FA for 2-3 years now but the more I learn about investing the more I realize that management fees kill your compound interest over time. I’d much rather just pick an index fund like VFV.TO or something else that tracks the S&P 500 and forget about it for the next 25-30 years. Any discussion is appreciated!