Optimizing stored procedures

[Heiko Giesselmann]

Hi,

I have a couple of stored procedures that are critical for performance. 
The tables accessed by select statements in the stored procedures have 
indexes defined. Still, execution performance is pretty bad and indexes 
don't seem to be used (according to 'Tuning - index use' information).

Indexes are being used when the same select statements are executed 
directly (no stored procedure). I have run update statistics but that 
didn't seem to have any effect. Kernel is 7.5.0.8.

Anybody any ideas?

Thanks, Heiko