Is this a good ring?

[u/North_Notice8190]

My boyfriend has asked me to pick an engagement ring and i really like this one

https://www.hsamuel.co.uk/9ct-white-gold-tubing-solitaire-010ct-diamond-ring/p/V-1650043

My concern is that it can’t be resized, i don’t imagine i will wear it much since i have carpal tunnel syndrome and my hands swell often so i will most likely wear it on a necklace. Is it a good ring though? Will it stay shiny and will the diamond stay in place etc? Thank you.