SAP HANA Storage Simulation

Experience the power of in-memory computing with SAP HANA

Storage Type Selection

Query Execution

code

Query Editor

timer Execution Time: -

memory Memory Usage: -

table_chart

Query Results

Performance Comparison

Transactional Queries

Execution Time (lower is better)

Row Storage

15 ms

Column Storage

45 ms

Analytical Queries

Execution Time (lower is better)

Row Storage

850 ms

Column Storage

120 ms

lightbulb

Key Insights

Row storage excels at transactional queries (OLTP) that need to access complete records, but struggles with analytical workloads that scan large datasets.

Column storage excels at analytical queries (OLAP) that only need specific columns, delivering significantly better performance for data warehousing and reporting.

SAP HANA's hybrid approach allows you to use both storage models in the same database, optimizing each table for its specific workload.