Does anyone have an idea about the performance issues regarding JOIN's?
If I have two tables
UID | INFO
UID | INFO2
and the two of these are over a million records, being hit regularly but 10's of thousands of web users
What kind of impact would I have seleting INFO1 and INFO2 using a JOIN?
Thanks in advance