Efficiency in querys with different schemas [Mysql]

Question

Is there any loss of efficiency making querys in different schemas?

For example query 1 is more efficient than query 2?

1: SELECT * FROM SC1.T1 INNER JOIN SC1.T2 ON ...

2: SELECT * FROM SC1.T1 INNER JOIN SC2.T2 ON

Answer 1

Independe, What really needs to be taken into account are the indexes, so always in JOIN you need to use indices to do the search yes will bring efficiency and robustness to your query!