Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    80

    Unanswered: FIX WARNING SQL0437W Performance of this complex query may be sub-optimal. Reason c

    Hi,

    I am getting the below warining when i join a the tablea with tableb(this table doesnt have any keys or constraints) which inturn is leading to the below warning. I am running the query from datastage which doesnt allow to run the query when it generates the warnings. so how can i proceed now?

    SQL0437W Performance of this complex query may be sub-optimal. Reason code:

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Maybe there are invalid statistics?
    (BTW, what was the Reason code?)
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •