SAP HANA Dynamic Tiering (Extended Tables)
Tutorials that teach this
- Tutorial Initializing Database Backup and Recovery
- Tutorial Additional checks in SAP HANA Cockpit and SAP HANA Studio
- Tutorial Converting Between an In-Memory Table and an Extended Table
- Tutorial Create Tables and Import Data
- Tutorial Create Extended Storage
- Tutorial Monitoring SAP HANA Using SAP HANA Cockpit and SAP HANA Studio for SAP HANA Dynamic Tiering
- Tutorial Reviewing Available Backups
- Tutorial Selectively Move Data Between In-Memory and Extended Tables
- Tutorial Create Extended Storage
- Tutorial Seeing Calculation View Results
- Tutorial Enlarging a Dbspace File Using Reserved Space
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Table Statistics and its Effect on Query Plans
- Tutorial Managing Backup Files
- Tutorial Create a New User and Assign Permissions
- Tutorial Migrate Records in Related Tables Using Stored Procedure
- Tutorial Multi-Store Tables
- Tutorial Disable SAP HANA System Replication
- Tutorial Creating Database Backups
- Tutorial Dropping a Dbspace File
- Tutorial Creating and Removing Extended Storage
- Tutorial Stopping and Restarting the Extended Storage Service
- Tutorial Adding a Dbspace File
- Tutorial Create a New User and Assign Permissions
- Tutorial Compare Prepared and Executed Plan
- Tutorial Detailed Query Plan and Indexes
- Tutorial Create Tables and Import Data
- Tutorial Creating a Calculation View from the Union of In-Memory and Extended Tables
- Tutorial Importing Required Calculation Views
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Create Multi-Store Tables
- Tutorial Performing a Failback
- Tutorial Creating and Recovering Delta Backups
- Tutorial Convert Between an In-Memory Table and an Extended Table
- Tutorial Visualize a Graphical Query Plan
- Tutorial Adding Our Union Calculation View into the Converted Data Model
- Tutorial Setting Up SAP HANA System Replication with HANA Studio
Prerequisites
- Concept SAP HANA Information Views (Attribute, Analytic, Calculation)
- Concept Union Node in SAP HANA Calculation Views
- Concept SAP HANA Database Administration
- Concept SAP HANA Backup and Recovery
- Concept SAP HANA Architecture and Internals
- Concept SAP HANA Cloud fundamentals
- Concept SAP HANA In-Memory Relational Database
- Concept SAP HANA Security and User Management
- Concept SAP HANA In-Memory Platform Fundamentals
- Concept SAP HANA database management
- Concept SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
- Concept SAP HANA Cockpit POST API Usage
- Concept Extended Storage Dbspace Creation and Removal
- Concept SAP HANA Calculation Views
- Concept SAP Web IDE for SAP HANA
Concepts that build on this
- Concept SAP HANA Dynamic Tiering Query Plan Analysis and Index Creation
- Concept SAP HANA Smart Data Access (SDA)
- Concept SAP HANA Dynamic Tiering Recovery
- Concept CSV Bulk Data Import and Batch Processing
- Concept SQL UNION ALL for Combining Result Sets
- Concept SQL Explain Plan for Query Execution Analysis
- Concept Extended Storage Dbspace Creation and Removal
- Concept SAP HANA System Replication Takeover
- Concept SAP HANA HDBSQL Command-Line Tool Basics
- Concept SAP HANA High Availability and Disaster Recovery
- Concept SAP HANA Multi-Store Tables
- Concept SAP HANA Database Administration
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept Selective Data Migration Between In-Memory and Extended Storage
- Concept SAP HANA Modeler Perspective in SAP HANA Studio
- Concept SAP HANA Information View Conversion to Calculation Views
- Concept SAP HANA Backup and Recovery
- Concept SAP HANA Monitoring Views (M_ prefix)
- Concept Foreign Key Constraints and Referential Integrity