Running an OLTP query in SAP HANA

SAP HANASAPSAP Basis

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.

raja
Published on 05-Feb-2018 17:31:08
Advertisements