enums depend on the database. In general they're better than categorical strings (varchar columns) if the number of categories is below 256. The primary benefit is data quality (no typos allowed), but performance benefits also exist.