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.
Thanks for your help.


Guido

"Leyne, Sean" wrote:

> Guido,
>
> Can I impose on your patience again?
>
> Could you list the indexes which exist for each table.
>
> 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/