Database field enum kind of type

Hi, For those you have experience with databases for big data (RDBMS), I have a question what is on the back of my head for a long time. If you have a table called user with a status field, do you prefer for it to be (or the best in terms of performa...