Learn to create extended and multi-store tables using SAP HANA dynamic tiering, as well as load data and move data between default storage and extended storage. This is an updated version of the original Get Started with SAP HANA Dynamic Tiering tutorial series, but now using SAP Web IDE instead of SAP HANA studio.
Create a new TPCH user and assign roles and privileges to the new user.
Check the extended storage status for the HANA System and creating extended storage to enable dynamic tiering.
Create in-memory column store and dynamic tiering tables. Import data into both types of tables.
Convert between an in-memory and an extended table (and vice-versa) using SQL scripts in SAP Web IDE for SAP HANA.
Use a stored procedure to migrate records in related tables as a single transaction.
Create and use a SQL view to query data from both in-memory and dynamic tiering tables.
Learn about multi-store tables, partition types, and create a multi-store table
Joule is an AI assistant. Generative AI may produce inaccurate, incomplete, or biased information. Always verify important details before acting on them.
Conversations are sent to SAP-hosted large language models for processing. Do not include personal data, credentials, or confidential information in your messages.
Joule's responses are based on the SAP tutorial catalog and may not reflect the latest product changes. For authoritative guidance, consult the linked tutorials and official SAP documentation.