Subject | Re: [ib-support] Server configuration |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2001-10-05T13:44:43Z |
Wait, one last question:
Statement:
--------------------------------------------------------------------------------
for select NAME1,NAME2,NAME3,DASTREET,DAPOSTBOXZIPCODE,DAPOSTBOX,DAZIPCODE,
DACITY,DADIALLINGCODE,DATELEPHONE,DAFAX,CLASS,SALES_REP,REGION,NRFIRST,
NRLAST,INSTORE,BRANCH,CHANNEL,OUTLET_NR,GROUP_MAIN,GROUP_SUB,OUTLETS_A,
OUTLETS_B,OUTLETS_C,TURNOVER
from DOS_CUSTOMERS into :NAME1,:NAME2,:NAME3,:DASTREET,:DAPOSTBOXZIPCODE,
:DAPOSTBOX,:DAZIPCODE,:DACITY,:DADIALLINGCODE,:DATELEPHONE,:DAFAX,
:CLASS,:SALES_REP,:REGION,:NRFIRST,:NRLAST,:INSTORE,:BRANCH,:CHANNEL,
:OUTLET_NR,:GROUP_MAIN,:GROUP_SUB,:OUTLETS_A,:OUTLETS_B,:OUTLETS_C,:TURNOVER do
Plan:
--------------------------------------------------------------------------------
(DOS_CUSTOMERS NATURAL)
Could I speed up this statement in any way ? It does nothing else, than work through all datasets of the table DOS_CUSTOMERS.
Guido
Statement:
--------------------------------------------------------------------------------
for select NAME1,NAME2,NAME3,DASTREET,DAPOSTBOXZIPCODE,DAPOSTBOX,DAZIPCODE,
DACITY,DADIALLINGCODE,DATELEPHONE,DAFAX,CLASS,SALES_REP,REGION,NRFIRST,
NRLAST,INSTORE,BRANCH,CHANNEL,OUTLET_NR,GROUP_MAIN,GROUP_SUB,OUTLETS_A,
OUTLETS_B,OUTLETS_C,TURNOVER
from DOS_CUSTOMERS into :NAME1,:NAME2,:NAME3,:DASTREET,:DAPOSTBOXZIPCODE,
:DAPOSTBOX,:DAZIPCODE,:DACITY,:DADIALLINGCODE,:DATELEPHONE,:DAFAX,
:CLASS,:SALES_REP,:REGION,:NRFIRST,:NRLAST,:INSTORE,:BRANCH,:CHANNEL,
:OUTLET_NR,:GROUP_MAIN,:GROUP_SUB,:OUTLETS_A,:OUTLETS_B,:OUTLETS_C,:TURNOVER do
Plan:
--------------------------------------------------------------------------------
(DOS_CUSTOMERS NATURAL)
Could I speed up this statement in any way ? It does nothing else, than work through all datasets of the table DOS_CUSTOMERS.
Guido