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:
http://www.as400tutorials.com/a-tale-of-two-engines/

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • copack
    Very interesting article.Thanks John.
    65 pointsBadges:
    report

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: