SAP HANA Multi-Store Tables
Multi-Store Tables are a type of SAP HANA table that allows developers to store data across multiple storage tiers within a single table object. Developers use them to optimize performance and cost by placing frequently accessed ("hot") data in in-memory storage while moving less frequently accessed ("warm" or "cold") data to lower-cost storage tiers. This approach enables efficient data lifecycle management without requiring application-level changes to query logic.
Tutorials that teach this
Prerequisites
- Concept SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY) The concept name was not provided, so a precise definition cannot be generated. Please supply a valid concept name along with supporting source snippets so that an accurate, grounded definition can be written.
- Concept SAP HANA Database Explorer The concept to be defined is missing or marked as "undefined," and the provided sources do not converge on a single, clearly identifiable SAP developer concept. Without a valid concept name, a grounded and accurate definition cannot be produced.
- Concept SAP HANA In-Memory Relational Database The concept name was not provided (marked as "undefined"), and the available source snippets do not contain sufficient detail to construct a grounded, accurate reference definition. Only one source ([S1]) references a relevant topic — setting up database artifacts using SAP HANA — but without a named concept to define, a precise and accurate definition cannot be written per the documentation guidelines.
- Concept Extended Storage Dbspace Creation and Removal The concept name is missing or undefined, and the provided sources discuss SAP HANA Dynamic Tiering topics such as extended storage, dbspace file management, and monitoring via SAP HANA Cockpit and SAP HANA Studio — but do not supply enough grounded detail to write a reliable definition for an unnamed concept. Please provide the concept name so an accurate, source-grounded definition can be written.
- Concept SAP HANA Database Administration The concept provided is **undefined**, and the supplied sources do not contain sufficient information to produce a grounded definition. Please provide a valid SAP developer concept name so an accurate and source-supported definition can be written.
- Concept SAP Web IDE for SAP HANA The concept name provided is "undefined," which does not correspond to a identifiable SAP developer concept. Based on the available sources — which cover former SAP development environments such as [SAP Web IDE](https://ui5.sap.com/#/topic/d3f5ad2ec52b4ed0b5a272c1ce52a6f3), SAP HANA XS Advanced, and related tutorials — no definition can be accurately constructed for a concept labeled "undefined." Please provide a valid concept name so that a precise, source-grounded definition can be written.
- Concept SAP HANA In-Memory Platform Fundamentals
- Concept SAP HANA Dynamic Tiering (Extended Tables) The concept name was not provided, so a precise definition cannot be written. Based on the available sources, the tutorials collectively cover SAP HANA topics such as dynamic tiering, system replication, SQL views, and query plan analysis — but without a specific concept to define, no accurate, source-grounded prose definition can be produced. Please supply the concept name so a proper definition can be written.
- Concept HANA Table Partitioning and Indexing The concept name was not provided, but based on the sources, this appears to relate to **HANA Table Partitioning**. It is a feature that allows developers and administrators to break down large columnar tables into smaller partitions in SAP HANA. Using apps such as [Partition HANA Tables (F5466)](https://help.sap.com/docs/btp/sap-business-technology-platform/c2af3162057f499c8495352ca364c263?locale=en-US&state=PRODUCTION&version=Cloud), developers can manage and optimize large datasets for improved performance. The [HANA Table Analysis app (F8726)](https://help.sap.com/docs/btp/sap-business-technology-platform/8ec349bd5fad4552a68f15d1c6909b60?locale=en-US&state=PRODUCTION&version=Cloud) complements this by providing in-depth information about tables to help identify candidates for partitioning.
- Concept HANA Column Store and Row Store Tables The provided sources do not contain sufficient information to write a grounded definition for an **undefined** concept. Please supply a valid concept name and relevant source snippets so an accurate, source-grounded definition can be produced.
- Concept SQL Console in SAP HANA Cloud Central The concept provided is **undefined** and no specific SAP developer concept was supplied for definition. Additionally, the provided sources are tutorial titles only, containing no substantive content snippets from which factual claims could be grounded. Please provide a valid concept name and supporting source content to generate an accurate reference definition.