Kbase P79861: Using TRIM Function causes table scan
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/24/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Progress query runs very slow
Using the TRIM Function because key field is padded to length of 30
DataServer is doing a full table scan
CAUSE:
The TRIM function caused the DataServer to have each record read and passed back to the client.
FIX:
Change the code to use some other function such as the BEGINS function [<database.field> BEGINS "<value>"] instead of the TRIM function [TRIM(database.field) = "<value>"]