Kbase P30234: Thousands of record reads occur when selecting from a SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Promon indicates thousands of record reads when selecting from a SQL-92 view.
The create view statement includes a conversion function.
The columns involved in the conversion are part of the base table.
CAUSE:
Converted columns of a base table are excluded from being used as part of the index. The predicates which SQL will use to search an index are predicates on
base table columns. If a predicate applies to the result of a SQL function, such as convert or substring, that predicate will not be used to search an index resulting in a high number of record reads.
FIX:
Remove the convert function from the create view statement on columns that are part of the searchable index.