Running an OLTP query in SAP HANA

When you have to run an OLTP query just to display the specific records, In row based storage, when you run a Select statement all the different datatypes come together so it will be much faster to run a SELECT statement in Row based storage.

Select * from FCT_SALES where Country=’US’;

When the same query is run in column based storage, you need to find the values of each column in database and it is time consuming so it is not recommended to create a column based storage tables when your queries are not aggregated and required to run simple SELECT statement.

Updated on: 24-Feb-2020


Kickstart Your Career

Get certified by completing the course

Get Started