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
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
