I am creating the new database and I have requirement to created 50 fields.
I want to design the tables/table which should be faster to access the data should be in seconds..
Please suggest the best options and pros and cons..
Option 1:Create a single denormalize table with 50 fields since it has one unqueID which is unique for the record.
Option 2:Normalize the tables and create more tables and relationship..
Thanks for your help in advance !