SAP
C_HANAIMP142 · Question #222
A customer wants to reproduce the following SQL statement in SAP HANA: SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P, PROD_TEXTS PT WHERE P.PROD_ID=PT.PROD_ID; Which of the following…
The correct answer is A. ot_products= CE_COLUMN_TABLE(PRODUCTS). See the full explanation below for the reasoning.
Question
A customer wants to reproduce the following SQL statement in SAP HANA:
SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P, PROD_TEXTS PT WHERE P.PROD_ID=PT.PROD_ID; Which of the following SQLScript constructs is equivalent to this SQL statement and yields the best performance?
Options
- Aot_products= CE_COLUMN_TABLE(PRODUCTS);
- BSELECT P.PROD_NAME, P.PROD_ID, NULL as PROD_DESC
- CSELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P
- Dot_products= CE_COLUMN_TABLE(PRODUCTS);
How the community answered
(31 responses)- A77% (24)
- B6% (2)
- C13% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.