Kbase P59766: Sometimes JOIN is faster than WHERE in SQL-92 engine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/17/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Sometimes JOIN is faster than WHERE in SQL-92 engine
CAUSE:
WHERE causes temptables to be used unnecessarily, and that's a performance penalty. JOIN doesn't do that.
FIX:
Use JOIN instead of WHERE.