Why do you create a row store instead of a column store table?

[parthkosarkar1]

1. You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings. Why do you create a row store instead of a column store table?

A.To limit the unpacking and reconstruction of rows

B.To allow creation of a full-text index

C.To limit the need of indexes

D.To limit the data footprint

what would be the answer of this and why can any one help me with this ?

[jhodel18 · Accepted solution]

The answer is A, because a row store table all the columns for the row hence you don't need to unpack and reconstruct the columns of the rows. The other choices are describing a column store table.

[parthkosarkar1 · Accepted solution]

Thanks jhodel 🙂

clear with my point 🙂