I'm having problems with the speed of performance of my sps.

In the query analyzer, when I run an sp that uses 3 parameters to place data into a temporary table for a vb frontend, the run time is up at 1 minute plus.

If I run just the query and sql code in the query analyzer and then hardcode the 3 relevant parameters, it takes 1 second.

My tables have standard & clustered indexes and these same sps do run quickly in another copy of the database that I have (which has more data in it).

I'm doing something wrong, please, what is it?

Thanks