| Subject | Re: ORDER BY with LPAD is to slow |
|---|---|
| Author | danyschaer |
| Post date | 2008-06-19T12:57:15Z |
Very nice!
I changed to
select cast(LPAD(lower(trim("EXP1")),18) as character(18)) as "XX"
from "PROC" order by "XX"
and it is very quickly now.
Thank Helen an Dmitry!.
I changed to
select cast(LPAD(lower(trim("EXP1")),18) as character(18)) as "XX"
from "PROC" order by "XX"
and it is very quickly now.
Thank Helen an Dmitry!.