RE: SQL

Jim,

Pardon me for jumping in, but the query estimator is prone to
over-estimating under many conditions.  They try to PTF it as they find
problems.  If you haven't put on the Database Group PTF for your OS/400
release in a while, you may want to try that.  You also may want to turn off
the query time limit and try the SQL statement at a quiet time.  If it does
run forever, kill it, but I'll bet it will finish in a reasonable time.

Dave Shaw
MAPICS-L Moderator
Rauch Industries, Inc.
Gastonia, NC

-----Original Message-----
From: J.Bloemsaat [mailto:bloemsaat@axias.com]
Sent: Friday, March 01, 2002 3:27 AM
To: mapics-l@midrange.com
Subject: RE: SQL


Jim,

You are sure you entered the example correct ?
The message contains actualy a copy of the statement I executed here on our
own systrem (720).
It runs fine.


Met vriendelijke groet
Yours sincerely
Bien a vous

Jules Bloemsaat
bloemsaat@axias.com


-----Original Message-----
From: mapics-l-admin@midrange.com [mailto:mapics-l-admin@midrange.com]On
Behalf Of Jim Wiedl
Sent: dinsdag 26 februari 2002 20:27
To: mapics-l@midrange.com
Subject: RE: SQL


Your SQL statement looks good, except when I try to run it I get a message
that the time limit will exceed the query limitations.  The estimated run
time is 1billion 626 million seconds!