Baffled by SQL - again :-))

Posted in 2000

Watson, Paul — Wed, 29 Nov 2000 11:26:44 -0000 — source: Informix-list mailing list archive (1991-1998)

Consider the following SQLs select post_code, prod_id, count(*) from eric group by 1,2 having count(*) !=1 select trim(post_code), trim(prod_id), count(*) from eric group by 1,2 having count(*) !=1 The second uses a huge amount sort area (/tmp), whereas the first doesn't. Why? Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix #