If you have taken all of the above steps and still think that your queries could perform better, then there are two diagnostic steps that we typically recommend:

Proper interpretation of these cannot be covered in this guide, so please contact Actian Support for assistance.