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
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
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.
Thank you for the reply Aloiso!
– André Luiz Bittencourt