Ask a Question related to IBM DB2, Design and Development.
-
cricri #1
db2 et sql
hello,
I don't know why but I have a little pproblem with some sql request.
some time they need 0,9 seconde, some time 4 or 7 secondes some time 4
or 5 minutes ??
Please help me ;)
the request :
SELECT ECHCDDOS, ECHCDGG, ECHUPDAT, ECHCDVIN, ECHDENSPRD, ECHFINSPRD
, ECHNSPRDE, ECHDTEXP, ECHNUMACC, ECHCDCLI, ECHMODPRDE, ECHSTATD, EC
HNSPRR, ECHCDDOSRM, ECHNUACCRM, ECHRMULT, ECHDTEXR, ECHMODPRD FROM
XELONFIC/ECHDOSPF WHERE ECHCDGG=1 AND (ECHFINSPRD='10112487' OR ECHN
SPRDE like
'%10112487%') AND ECHCDDOS<>'I000036386' ORDER BY echfinsprd,
echcddos, ECHCDGG
cricri Guest



Reply With Quote

