| In the Forums... |
|---|
|
| IC63347: QUERY USING OUTER, GROUP BY AND DYN.... |
|
|
Spread the news
| 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 |
| < Prev | Next > |
|---|
| DBA Zone | |
|---|---|
|
| Main Menu | |||||
|---|---|---|---|---|---|
|
| Newsflash | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Ads |
|---|
| Login Form |
|---|