Thomas,
you are right - I did use literals outside the procedure. But this
should not really make a difference, right?
Thanks, Heiko
Anhaus, Thomas wrote:
>Heiko Giesselmann wrote :
>
>
>
>>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?
>>
>>
>
>Actually there should be no difference between select statements executed from
>a stored procedure and the same select statement executed from any other environment.
>Are you really sure, that you executed exactly the same select statement outside the
>stored procedure, or did you pass the qualification values via parameters
>inside the procedure and via literals outside the procedure ?
>This could explain the different strategies used.
>
>Best Regards,
>Thomas
>
>
>
>
