vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/ddm/umn/ddm_04_0016.html
Hasko, Vladimir a5cc543164 reverting ddm umn to state before last commit in #613 
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-committed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
2024-01-17 13:06:49 +00:00

1.0 KiB
Raw Permalink Blame History

How Do I Optimize SQL Statements?

  • You are advised to use INNER instead of LEFT JOIN or RIGHT JOIN.
  • When LEFT JOIN or RIGHT JOIN is used, ON is preferentially executed, and WHERE is executed at the end. Therefore, when using LEFT JOIN or RIGHT JOIN, ensure that the conditions are judged in the ON statement to reduce the execution of WHERE.
  • When possible, use JOIN instead of subqueries to avoid full scanning of large tables.
Parent topic: SQL Syntax