Table DOS_CUSTOMERS: No index
Table CLASSES: CLID is PK, Index on CLNAME
Table SALESAREAS: SAID is PK, Index on SANAME
Table INSTORES: INID is PK, Index on INNAME
Table BRANCHES: BRID is PK, Index on BRNAME
Table CHANNELS: CHID is PK, Index on CHNAME
Table GROUPS: GPID is PK, Index GPNAME
Table DOS_CONSTANTS: Index on SHORTCUT and NAME


"Leyne, Sean" wrote:

> Guido,
>
> > Now I see, what do you think, what the problem is. I have
> > created two new indices on DOS_CONSTANTS and now the SP takes
> > only half the time.
>
> I'm glad to hear your making some progress in reducing the run time of
> the SP. But I think it can be improved much further, accordingly can
> you still give us/me the index information.
>
> 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/