I would like understand tkprof about an Insert

hello,

    I have retrieved this query about an insert  and I do not understand between the time cpu and the time elapsed.
Why the the time elapsed is very higher than the cpu ?
                                cpu       elapsed

      Execute      1      1.91      22.47
And how can I improve the elpased time ? by an Procedure stocked ?

thanks for your help.

best regards

Jean-Pierre

 

INSERT INTO diu00SUI.FMK_DATA_TRACE (NUMLOT,GROUPE,CODE_EVT,TN_IDTSEQ,COLONNE,
  VALEUR,TYPE_ERR) SELECT NUMLOT,'MP1I' as Groupe,'MP1ISTOCK' as Code_evt,
  TN_IDTSEQ,'DD_DTERDV'as Colonne, DD_DTERDV as  Valeur , 'CheckDate' as
  TYPE_ERR from diu00PRI.T_TCLOD_MP1ISTOCK#8  WHERE TESTDATE(DD_DTERDV,'N',