SAP HANA SQLScript · Clean SQLScript Code

To speed up a slow scalar user-defined function, a colleague adds the DETERMINISTIC keyword and a small SELECT ... FROM DUMMY inside it. What's wrong with both moves?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Clean SQLScript Code

Using the team's Hungarian notation, decode what IV_MAX_ROWS and LT_MATERIAL each are.

Following Knuth, when should you tune a SQLScript query for performance, and why not sooner?

The chapter lists four primary code requirements: correctness, maintainability, performance, and production efficiency. Which quality does the author call the prerequisite for reaching all of them?

You press the format button in SAP HANA Web-Based Development Workbench on a stored procedure. What actually happens?

In one code base the MARA material is called MATNR in one place, MATERIAL in another, and MAT elsewhere. Why is that a readability defect even though each name is valid on its own?

In the SQLScript Hungarian-notation convention, the first letter of a variable name encodes its kind. Which kind-prefix is SQLScript-only, and which ones are ABAP-only?

Start learning today

Free to start — download the app or use it in your browser.