Given the following ABAP SQL statement excerpt from an ABAP program: You are given the following information: 1. The data source “spfli” on line #2 is an SAP HANA database table. 2. “spfli” will be a large table with over one million rows. 3. This program is the only one in the system that accesses the table. 4. This program will run rarely. Based on this information, which of the following general settings should you set for the spfli database table? (Choose two.)

Select an option, then click Submit answer.
Reference / correct answer:
“Storage Type” to “Column Store”
Most accepted answer: B. “Storage Type” to “Column Store”
Community votes: B=1, C=1
Selected Answer: BC Row store should only be used in SAP HANA databases if the database table is used mainly for frequent single row accesses. Page Loadable is used for large tables with less frequent accesses. upvoted 2 times TETRIS123 1 year, 2 months ago Page Loadable cannot be used for database tables with storage type Row store. upvoted 1 times ... TETRIS123 1 year, 2 months ago https://consolut.com/supportportal/sap-online-help/ansicht-dokumentation/?article=B-ABENDDIC_DATABASE_TABLES_LOAD_UNIT upvoted 1 times ...
Page Loadable cannot be used for database tables with storage type Row store. upvoted 1 times
https://consolut.com/supportportal/sap-online-help/ansicht-dokumentation/?article=B-ABENDDIC_DATABASE_TABLES_LOAD_UNIT upvoted 1 times