Creating a separate to manage SET options
Posted by: Enyinna Ibekwe
Date: August 14, 2015 11:10AM

Hello,

On creating a new database, I discovered that most of my tables were to have a good number of columns with the data type SET eg "male", "female", "yes" or "no".

I am now considering ripping all these off and forming a new table to manage all my sets then call the required id from wherever they are needed. eg

set_option_table
id > 1.............title > yes

id > 2..............title > Male



Gender_table
gender > 2

own_a_car > 1


Then in my code, I'll combine the two tables



QUESTION: When tables become so large, will there be any regrets in doing this? (though I know Mysql will be faster in delivering results in numbers)

Options: ReplyQuote


Subject
Written By
Posted
Creating a separate to manage SET options
August 14, 2015 11:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.