AS/400 Programming Tips, Tricks, & Techniques

Nov 6 2012   3:59PM GMT

All About the SQL Query Engine

John Andersen Profile: John Andersen

In my past posts I mentioned the SQL Query Engine that evaluates, plans and drives your SQL queries on the IBM i platform. For speed and performance you really should understand why using the SQE is where its at.

Here is a good article that dives more deeply into the SQE versus the CQE engines on your system:

If performance is a concern and you are still using Query/400, OPNQRYF or the QQQQry API you are blowing it big time!

Here are the key takeaways from the article:
Use SQL driven tools and programs that utilize the SQE…
Why it pays to stay current with your IBM i OS level and more importantly the Database Group PTFs that contain new features.
Utilities to monitor database performance and optimization.

-John Andersen

1  Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • copack
    Very interesting article.Thanks John.
    65 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: