MySQL Cross Schema Joins

Doing a lot of cross schema joins for some shared data...

SELECT cols FROM schema1.table INNER JOIN schema2.table ...


Just curious if there is any particular caveats to doing this?  Any special indexes that need to be created, any optimization tips...
LVL 1
mynamebecory2Asked:
Who is Participating?
 
dodge20Commented:
Generally the rule of thumb is that any field that you use as a join should have an index. There may be some exceptions, but you are pretty safe doing this. Otherwise no caveats. Pretty standard in databases.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.