"Carlos H. Reimer" <carlos.reimer@xxxxxxxxxxxxx> writes: > I know that the problem with the following SQL is the "LOG.CODCEP = > ENDE.CODCEP||CODLOG" condition, but what can I > do to improve the performance? Seems the problem is not using an index for tt_log. Do you have an index on tt_log.codcep? If so, maybe you need to cast the result of the concatenation to char(8) to get it to use the index. regards, tom lane
