Efficiency in querys with different schemas [Mysql]

Asked

Viewed 33 times

1

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
mysql sql database performance

1 answer

0


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!

Browser other questions tagged mysql sql database performance

You are not signed in. Login or sign up in order to post.