Query Result Caching and Spill to Disk

Query Result Caching and Spill to Disk

During this video we provide a demonstration of how to make use of the new Query Result Caching feature introduced with the release of Vector 6.2 and the Spill to Disk feature released in Vector 6.3

rate limit

Code not recognized.

About this course

At the end of this course you will:

Have gained an understanding about the Query Result Caching feature including how to implement, configure and monitor that the feature is performing as expected.  Additionally gain an understanding for the Spill to Disk feature released in Vector 6.3.

Course Style:
The content is presented in a how to style in order for you to follow along within your own database environment
Audience:
For System or Database Administrators who have responsibility for ensuring that Corporate Databases and Data Warehouses are performant at all times.
Prerequisites:

The Query Result Caching functionality is available from Actian Vector 6.2 onwards and the additional Spill to Disk functionality is available from Actian Vector 6.3 onwards.

Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

 

Curriculum9 min

  • Query Result Caching 8 min
  • Feedback
  • Take Course Survey 1 min

About this course

At the end of this course you will:

Have gained an understanding about the Query Result Caching feature including how to implement, configure and monitor that the feature is performing as expected.  Additionally gain an understanding for the Spill to Disk feature released in Vector 6.3.

Course Style:
The content is presented in a how to style in order for you to follow along within your own database environment
Audience:
For System or Database Administrators who have responsibility for ensuring that Corporate Databases and Data Warehouses are performant at all times.
Prerequisites:

The Query Result Caching functionality is available from Actian Vector 6.2 onwards and the additional Spill to Disk functionality is available from Actian Vector 6.3 onwards.

Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

 

Curriculum9 min

  • Query Result Caching 8 min
  • Feedback
  • Take Course Survey 1 min