hi,

Recently I experience a strange phenomenon,
in the clauses that baan sends to oracle. it
places +0 in primary keys, which it provokes
losses in performance.

FROM
baan.ttdsls041104 a, baan.ttdsls300104 b,
baan.ttdpur041104 c, baan.ttrtoc600104 d,
baan.ttcmcs036100 e, baan.ttcmcs003104 f
WHERE f.t$cwar (+) = a.t$cwar
AND e.t$ccty (+) = a.t$ccty
AND e.t$cvat (+) = a.t$cvat
AND d.t$ctrj (+) = a.t$ctrj
AND c.t$orno (+) = a.t$****
AND c.t$pono (+) = a.t$ppon
AND b.t$cono (+) = a.t$cono
AND a.t$orno+0 = :1 <----------

Can anybody help me ?


Regard
jc

Please trace the application query as it is probably added there already. It is probably added to improve the performance :).

When adding this construction, the specified field will not be used for selecting or hinting an index.

Hope this helps,
Dick

This phenomenon happens in all the programs master/detail for two weeks

Please check the ora_storage file. Probably the 5th field contains something like 034 instead of 0214. Try the change and let us know.

Kind regards,
Dick

Thank you,

Exactly, the file had the value 024.

This was the problem.


Thank you again