I used to always use SYS_GUID. I stopped when Identity Columns came along and when I heard that they took up so much space. Also, this is worth a read: raajeshwaran.blogspot.com/2016/12/guid-or-sequenc… I do still use SYS_GUID when I need unique values across instances.