B
BMS
I have a series of 8 tables that I need to link together to create one large
table. I am curious what the quickest way to do this is. Is it better to
link all of them together in 1 query or to do a step by step progress where
is link 4 together into 1 table and 4 together into a second table and then
link those 2 together.
This was actually working just fine when I had 7 tables linked together, but
I added an 8th table and the query time doubled. And I actually tried to
apply primary keys and indexes and this just increased the processing time
even more (especially the indexes).
Any suggestions?
table. I am curious what the quickest way to do this is. Is it better to
link all of them together in 1 query or to do a step by step progress where
is link 4 together into 1 table and 4 together into a second table and then
link those 2 together.
This was actually working just fine when I had 7 tables linked together, but
I added an 8th table and the query time doubled. And I actually tried to
apply primary keys and indexes and this just increased the processing time
even more (especially the indexes).
Any suggestions?