Slow query when using parameters

From: <pmartin_at_mitsa.ch>
Date: 2000/03/31
Message-ID: <8c1m45$kg$1@nnrp1.deja.com>#1/1

Hello

I've got a performance problem with a query. The query is in a procedure in a package (although this seems to make no difference).

The parameters for the query are passed as arguments to the procedure.

With the parameters passed as arguments the query takes 1 minute 40 seconds to run. However if I 'hardcode' the paramter values the query only takes 11 seconds to run.

I've tried putting the parameters passed to the stored procedure into local variables and then use the local variables in the query but this doesn't change anything.

Can anybody explain this difference ?

Many thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 31 2000 - 00:00:00 CST