Here are the PLAN informations:
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)

Statement:
--------------------------------------------------------------------------------
select CL.CLID from CLASSES CL,DOS_CONSTANTS TMP where TMP.ID=21 and
TMP.SHORTCUT=:CLASS and TMP.NAME=CL.CLNAME into :CLID;

Plan:
--------------------------------------------------------------------------------
JOIN (TMP NATURAL,CL INDEX (I_CLNAME_D_U))

Statement:
--------------------------------------------------------------------------------
select CL.CLID from CLASSES CL,DOS_CONSTANTS TMP where TMP.ID=21 and
TMP.SHORTCUT=:CLASS and TMP.NAME=CL.CLNAME into :CLID;

Plan:
--------------------------------------------------------------------------------
JOIN (TMP NATURAL,CL INDEX (I_CLNAME_D_U))

Statement:
--------------------------------------------------------------------------------
select SA.SAID from SALESAREAS SA,DOS_CONSTANTS TMP where TMP.ID=3 and
TMP.SHORTCUT=:REGION and TMP.NAME=SA.SANAME into :SAID;

Plan:
--------------------------------------------------------------------------------
JOIN (TMP NATURAL,SA INDEX (I_SANAME_D_U))

Statement:
--------------------------------------------------------------------------------
select SA.SAID from SALESAREAS SA,DOS_CONSTANTS TMP where TMP.ID=3 and
TMP.SHORTCUT=:REGION and TMP.NAME=SA.SANAME into :SAID;

Plan:
--------------------------------------------------------------------------------
JOIN (TMP NATURAL,SA INDEX (I_SANAME_D_U))

Statement:
--------------------------------------------------------------------------------
select INID from INSTORES where INNAME=:INSTORE into :INID;

Plan:
--------------------------------------------------------------------------------
(INSTORES INDEX (I_INNAME_D_U,I_INNAME_A_U))

Statement:
--------------------------------------------------------------------------------
select BRID from BRANCHS where BRNAME=:BRANCH into :BRID;

Plan:
--------------------------------------------------------------------------------
(BRANCHS INDEX (I_BRNAME_D_U,I_BRNAME_A_U))

Statement:
--------------------------------------------------------------------------------
select CH.CHID from CHANNELS CH,DOS_CONSTANTS TMP where TMP.ID=5 and
TMP.SHORTCUT=:CHANNEL and TMP.NAME=CH.CHNAME into :CHID;

Plan:
--------------------------------------------------------------------------------
JOIN (TMP NATURAL,CH INDEX (I_CHNAME_D_U))

Statement:
--------------------------------------------------------------------------------
select CH.CHID from CHANNELS CH,DOS_CONSTANTS TMP where TMP.ID=5 and
TMP.SHORTCUT=:CHANNEL and TMP.NAME=CH.CHNAME into :CHID;

Plan:
--------------------------------------------------------------------------------
JOIN (TMP NATURAL,CH INDEX (I_CHNAME_D_U))

Statement:
--------------------------------------------------------------------------------
select GPID from GROUPS where GPNAME=:GROUP_MAIN into :GPID2;

Plan:
--------------------------------------------------------------------------------
(GROUPS INDEX (I_GPNAME_D_U,I_GPNAME_A_U))

Statement:
--------------------------------------------------------------------------------
select GPID from GROUPS where GPNAME=:GROUP_SUB into :GPID3;

Plan:
--------------------------------------------------------------------------------
(GROUPS INDEX (I_GPNAME_D_U,I_GPNAME_A_U))




guido.klapperich@... wrote:

> How do I get these information ?
>
> Guido
>
> "Leyne, Sean" wrote:
>
> > Guido,
> >
> > Could you please provide the PLAN information for each of the queries
> > executed in the SP.
> >
> > Sean
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/