All SQL-based RDBMS '(up to 10 years of version):
Join questions directly in the tables (With no hint instructions) Does it matter for optimum performance and memory management? I have heard that the last to be included is the biggest table. How do your DB query optimizers handle this scenario?
Just to add more to the topic ... yes and no, depends. This is my answer, it depends on many factors, which include the type of RDBMS (MySQL, MSSQL Server, Oracle, DB2 ...), type of tables (aka number of rows), indexed and more Are using
Yes and does not say in the previous replies and appeals to the use of signals on questions. But your question is that
Does an inclusion statement make a difference in the order of tables ...
In my opinion, use it outside As the query signal, you are forced to use the query optimizer to use your suggested order.
Then, by re-using your answer to the question, Mark Bracket correctly states that your reconnecting combination (without query signals) does not affect performance because the query adapter current query Will still use the most efficient execution plan. Maybe it will not be the most efficient so that you can use the gesture and use whatever order you want and therefore modify the query execution plan.
More discussion on the topic at the following link:
Comments
Post a Comment