Make sure you have with distribution and indexes all as part of that
runstats.




"sumeet"
<db2udbdba-ezmlms
hield-x20898676.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
01/27/2005 04:54
PM Subject
RE: SQL SUBOPTIMAL help please...











Hey Folks,

Since we have upgraded from Db7.2 to DB2 8.2 to DB2 8.2 fix pack 7a we
are getting the This SQL Error. We run DB2 on AIX 5.1 Unix Server.

insert into PS_HBC_CUSTR_LKUP_wk select * from PS_HBC_CUSTR_LKUP a where
substr(a.FI_INSTRUMENT_ID,1,3) IN ('XIM','XAM','XST','XCL') and
a.fi_instrument_id = ( select b.HBC_INSTRUMENT_FR from PS_HBC_INSTRUMENT b
WHERE b.HBC_INSTRUMENT_FR = a.fi_instrument_id)
SQL0437W Performance of this complex query may be sub-optimal. Reason
code:
"6". SQLSTATE=01602

Other than this message We also out ETL Processes which load data into
Tables from Flat Files have been running 4 to 5itmes faster.

Can someone please help us in this issue?

Thank You,

Sumeet Agarwal
Technology & Solutions
Ph: 312-293-4976
sumeet.[Email address protected]
Fax: 312-461-7333





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page