How to capture an Actian Zen SQL Query plan and use the Query Viewer feature.

How to capture an Actian Zen SQL Query plan and use the Query Viewer feature.

During this course supported best practice guidance is provided for capturing an Actian Zen SQL Query plan and, utilising the Query Viewer feature to review the efficiency of the SQL query, optimize the query accordingly by applying or fine tuning table indexes.

rate limit

Code not recognized.

About this course

At the end of this course you will:
Have been provided with best practice advice and guidance for generating an Actian Zen SQL Query Plan and using the Query Viewer feature to analyse the query plan for efficiency and optimisation purposes.
Course Style:
The information is presented in a 'how to' style providing supported best practice advice and guidance.
Audience:
This course suits all personas who have responsibility for maintaining corporate Actian Zen Database instance(s).
Prerequisites:
The course content assumes:
Resource Links:
Software Download: https://esd.actian.com/

 

Curriculum5 min

  • How to capture an Actian Zen SQL Query plan and use the Query Viewer feature. 5 min
  • Feedback
  • Take Course Survey

About this course

At the end of this course you will:
Have been provided with best practice advice and guidance for generating an Actian Zen SQL Query Plan and using the Query Viewer feature to analyse the query plan for efficiency and optimisation purposes.
Course Style:
The information is presented in a 'how to' style providing supported best practice advice and guidance.
Audience:
This course suits all personas who have responsibility for maintaining corporate Actian Zen Database instance(s).
Prerequisites:
The course content assumes:
Resource Links:
Software Download: https://esd.actian.com/

 

Curriculum5 min

  • How to capture an Actian Zen SQL Query plan and use the Query Viewer feature. 5 min
  • Feedback
  • Take Course Survey