Re: puzzling problem with query

Posted in 2000

Obnoxio The Clown — Fri, 18 Feb 2000 13:55:54 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Tony Flaherty" <aef@mfs.misys.co.uk> > >Given that the one query retrieves a lot more rows than the other, could >this be a problem with the temp db space used for the group by temp table? IIRC, the bigger return set was coming back quicker... :-} ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

Tony Flaherty — Mon, 21 Feb 2000 10:01:34 -0000 — source: Informix-list mailing list archive (1991-1998)

DOH!, I'll have to put some time into this "reading things properly" skill my boss keeps talking about :-)) -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf . Obnoxio The Clown wrote in message <88jk9s$r1m$1@news.xmission.com>... > >From: "Tony Flaherty" <aef@mfs.misys.co.uk> >> >>Given that the one query retrieves a lot more rows than the other, could >>this be a problem with the temp db space used for the group by temp table? > >IIRC, the bigger return set was coming back quicker... :-} >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com >