Kbase P3195: Performance problem when using BY phrase in the WHERE clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/14/2006 |
|
Status: Verified
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 Development
FIX:
None at this time