Re: SQL problem -- batch vs. interactive

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

At 23:57 4/16/2004, Tom Liotta wrote:
> The following SQL statement runs in maybe 25 seconds in iSQL (V5R2, of 
> course, current PTFs) but a batch run as embedded SQL it takes a couple hours:

<snip>

Wow, that's almost as ugly as some of my queries. From what I understand, 
the query optimizer (wouldn't want to be in charge of that one) considers 
batch vs active as one of the variables when coming up with the access 
plan. In my experience, it's always been exactly the opposite. Interactive 
always seems to take much longer than batch. Maybe because of the 
interactive CPW penalty I suppose. I'd guess IBM would be interested in 
examining what's happening on your system. If you have a support contract, 
call them. The SQL guys are really quite good.


Pete Hall
pbhall@xxxxxxxxxxxxx
http://www.pbhall.us/