Is there any real benefit to using the ENUM type? Why not simply use a lookup table for the text description? Is there any performance difference? Listing the descriptions of the ENUM is certainly not straight forward. If the ENUMeration list will change periodically (adding strings), does the server take a performance hit because the table must be altered?
Any comments.
