Actian Data Platform Warehouse : Table Partitioning

Actian Data Platform Warehouse : Table Partitioning

Follow this guide to gain an elementary understanding of Table Partitioning and how to implement Table Partitioning.

rate limit

Code not recognized.

About this course

Course Outcome:
The training provided within this course will provide you with elementary information for the use of Table Partitioning within a Platform Warehouse. Partitioning is an essential strategy within a Platform Warehouse. The Platform Warehouse is designed to operate efficiently, making the best use of cluster resources, when at least one table in any nontrivial (joining) query is partitioned. Lack of appropriate partitioning can result in sub-standard performance; partitioning, therefore, must be considered and implemented at the beginning of the evaluation.Partitioning distributes the rows of a table among sub-tables (partitions). A partitioning scheme determines which rows are sent to which partitions
Course Style:
The training is provided in a step by step style providing you with best practice advice and guidance.
Audience:
For System or Database Administrators who have responsibility for maintaining the Corporate Actian Data Platform Warehouse(s).
Prerequisites:
  • You are a nominated Actian Data Platform Administrator for your organisation
  • Actian Data Platform login credentials are assumed to be available to you
Supplementary Resources:

Curriculum3 min

  • Actian Data Platform Warehouse : Table Partitioning 3 min
  • Feedback
  • Take Course Survey

About this course

Course Outcome:
The training provided within this course will provide you with elementary information for the use of Table Partitioning within a Platform Warehouse. Partitioning is an essential strategy within a Platform Warehouse. The Platform Warehouse is designed to operate efficiently, making the best use of cluster resources, when at least one table in any nontrivial (joining) query is partitioned. Lack of appropriate partitioning can result in sub-standard performance; partitioning, therefore, must be considered and implemented at the beginning of the evaluation.Partitioning distributes the rows of a table among sub-tables (partitions). A partitioning scheme determines which rows are sent to which partitions
Course Style:
The training is provided in a step by step style providing you with best practice advice and guidance.
Audience:
For System or Database Administrators who have responsibility for maintaining the Corporate Actian Data Platform Warehouse(s).
Prerequisites:
  • You are a nominated Actian Data Platform Administrator for your organisation
  • Actian Data Platform login credentials are assumed to be available to you
Supplementary Resources:

Curriculum3 min

  • Actian Data Platform Warehouse : Table Partitioning 3 min
  • Feedback
  • Take Course Survey