Just a generic question about tables.
If I had a table that 10 million entries in it, and there was a field in the table called "category" which housed a unique number from another table called categories, would it be faster for selecting records from this table via specific categories if the table was split apart into multiple tables via category?
So say something like this is the original.
- item_id, category_id, item_name
Then instead we create a bunch of these instead
- item_id, item_name
I'm thinking it might be faster to split the tables apart because it has less data to sort through, but then again it might be slower if you wanted to select data from multiple tables at the same time?