<div>
<div class="content wysiwyg-content">
Doing a lot of cross schema joins for some shared data...<br />
<br />
SELECT cols FROM schema1.table INNER JOIN schema2.table ...<br />
<br />
<br />
Just curious if there is any particular caveats to doing this? &nbsp;Any special indexes that need to be created, any optimization tips...
</div>
</div>


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...

MySQL Cross Schema Joins

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.