-
Course Objective
- Bulk and Batch Updates
-
Batch Updates 5 min
-
Query Working Memory 4 min
-
Force Propagation 1 min
-
Bulk Updates 6 min
-
Batch or Bulk? 5 min
-
Activity: Batch, Bulk Operations 10 min
- Database Procedures
-
Database Procedures 2 min
-
Statements Supported in Database Procedures 1 min
-
Scalar UDFs 1 min
- Indexes
-
Activity: Create an Index 8 min
- Query Optimizer
-
Query Optimizer 2 min
-
Create/Drop Statistics 2 min
-
Auto Statistics 3 min
-
Optimizer Statistics 1 min
-
Activity: Query Optimizer 10 min
- Query Execution Plans
-
Query Execution Plans 3 min
-
A Typical QEP 3 min
-
Activity: QEPs 10 min
- Reinforce your knowledge!
-
Course Quiz 10 min
- Feedback
-
Take Course Survey 1 min
Avalanche Cloud Data Platform Architect: Performance Optimization
Insight to improve query performance and discover how to use the inbuilt query execution plan to determine if a specific query is executing efficiently or not.
|
At the end of this course you will:
|
|
Know how data is stored in tables within the warehouse and what we need to know when performing data updates. You will also learn how applying statistics can enhance query performance and how to use the built-in query execution plan to assess whether a given query is being executed effectively or not.
|
|
Course Style:
|
|
The content is broken up into numerous lessons, which you are able to navigate as you wish; however, the course is not considered complete until all content has been viewed at least once. Each lesson presents a specific topic in an informative and how-to style.
|
|
Audience:
|
|
For architects who have a responsibility for designing solutions using the Actian Avalanche Platform.
|
|
Prerequisites:
|
|
The course assumes that you already have experience as a database/warehouse architect.
|
|
Resource Links:
|
|
Software Download: https://esd.actian.com/
Actian Community: https://communities.actian.com
Documentation: https://docs.actian.com/
|