I have 3 tables:
- table_1 - pri key is id+lang
- table_2 - pri key is id
- table_3 - pri key is id+lang (Full-Text table)
To join all 3 tables with their keys and run a full-text query, I understand I need to put
the Full-Text table at the end of the joins..
If I use the tables as defined above, then the join would be:
... FROM table_1 INNER JOIN table_2 ON table_1.id=table_2.id INNER JOIN table_3 ON
table_2.id=table_3.id AND table_1.lang=table_3.lang WHERE ...
The last join uses a primary key from both table_1 and table_2.. is that slower than a
case that table_2 key would be id+lang (which then the last join would use id+lang from
table_2 alone) ???