HI, I was wondering the general consideration when creating a new table in the db between choosing one table or two.
In my case I need to create table/tables that will store keywords from messages(there are two types of messages type a and b) and the number of
occurrences of the word in each of the different messages type. also I will need indication for hoe many total words are in in each of the different messages type.
so my question is I can eithe create one table :
and than every time I will need to get the total words for each words It will go over the whole table
or two table
1 wordTypeA wordType B
and than I can just count the number of rows for each table which is probably stored somewhere
but I have 2 table
anyway Its might be a stupid question but Ive been wonder about this type of issues for a while