Hi,
I have table called Media_table which has column Media_type. The data for Media type can be any of the "Movie","Trailer","Flash","Music" etc(almost fixed, not expected to change in near future,Or even if it changes also very minor updations very rarely). I thinking of two possibilities here 1. either to use the code table for the Media_type and join this table to Media_table(since its a Database standard) =20 2. use ENUM data type istead of code table. Performance is critical issue for the project. SO I am unable to decide which option should I go for.I have no clear Idea of all odd's of each option. If its other database like oracle 7.X/8 I would have used code tables itself, as they don't have any data type like ENUM. Any suggestions would be greatly appreciated.=20 Devi (Note:SQL/Query is used to bypass the filters) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
