Create a new TPCH user and assign roles and privileges to the new user.
Create in-memory column store and dynamic tiering tables. Import data into both types of tables.
Use a stored procedure to migrate records in related tables as a single transaction.
Learn about multi-store tables, partition types, and create a multi-store table
Check the extended storage status for the HANA System and creating extended storage to enable dynamic tiering.
Convert between an in-memory and an extended table (and vice-versa) using SQL scripts in SAP Web IDE for SAP HANA.
Create and use a SQL view to query data from both in-memory and dynamic tiering tables.
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.