AS/400 Query taking time to execute

5 pts.
Tags:
AS/400
AS/400 Query
I am having a query which is having 7 inner join One table having record around ==>4770290 And second table with ==>50681241 And other tables have comparatively less records.

Answer Wiki

Thanks. We'll let you know when a new response is added.

As Todd said, the correct Indexes on large files can really speed up processing.


I often find that taking the first few joins into an intermediate table and running a second SQL joining that to the results is sometimes much faster.

Discuss This Question: 1  Reply

 
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 members answer or reply to this question.

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
  • ToddN2000
    When dealing with large files in queries we were able to speed up time dramatically be creating logical files with the desired keys. We had one that was using a large non keyed file. It took about 35 minutes to run. Once we created the logical and modified query to use this logical it runs in about 2 to 3 minutes.  Just a suggestion. 
    15,605 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:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following