Kbase 33195: Performance problem when using BY phrase in the WHERE clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P3195
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
Progress 8.x
SYMPTOM(s):
Performance problem when using BY phrase in the WHERE clause
When the BY phrase is used the significant increase of I/OS against P__FILE schema file occurs
When the BY phrase is used, which doesn't match the existing index, the number of I/Os against database file doubles
When the BY phrase is used in a join of two tables the number of I/Os equals to the total number of records of the child table instead of the number of matching records
CAUSE:
This is a known issue being investigated by Progress Development.
FIX:
There is no fix information at this time