If I have a huge database and search on a fields (category) alphabetic wise, will it be faster than having 26 tables on basis of category A, category B, ..... Category Z and searching a single table by checking for 1st caharacter of category
i.e if category = 'development' then search table D only.
Which method is better. Is breaking up into multile tables desirable at all ?
Pls let em know about this issue on MySQL.
Thanx in advance