As developers get older, the next generation can face situations where the code they are looking at, they ask themselves why is that code there? They have never faced the pain of getting the code wrong or omitting a keyword or line where their predecessors learnt the hard way.
One such expression is “ORDER EXTERNAL BY” that you will come across in REPORT code. Whilst the meaning of ORDER BY is self-explanatory, the keyword EXTERNAL is often what is important and can lead to a performance difference, both in terms of the speed with which the report is generated and stability of the system.
Read more at
https://4js.com/ask-reuben/ig-234/
Sign in for full access
Help
