InformixMag, the only Informix Magazine - IC63347: QUERY USING OUTER, GROUP BY AND DYN....

You run a query that uses OUTER and GROUP BY. The optimizer uses a dynamic hash join that you can see in SQEXPLAIN output. The

Full title: IC63347: QUERY USING OUTER, GROUP BY AND DYN. HASH JOIN COULD RETURN WRONG RESULTS DEPENDING ON THE ORDER OF JOIN CLAUSES

Find more about it here.

Written by Robby Ivanovitch
Tuesday, 22 September 2009
You run a query that uses OUTER and GROUP BY. The optimizer uses a dynamic hash join that you can see in SQEXPLAIN output. The Full title: IC63347: QUERY USING OUTER, GROUP BY AND DYN. HASH JOIN COULD RETURN WRONG RESULTS DEPENDING ON THE ORDER OF JOIN CLAUSES Find more about it here. Find out more about Informix Dynamic Server (IDS). Copyright © 2009. All rights reserved. Copyright 2005 IBM Corporation