By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Stored Procedure - Help Needed

P: 1
Hi,

I've a stored Procedure, it fetches data from a temp table
Using that data it queries the DB using a single select statement
then it inserts into DB

But the peroformance is very poor
I'm using IBM db2

please give ur suggestions to improve the performance
Nov 1 '07 #1
Share this Question
Share on Google+
1 Reply


RedSon
Expert 5K+
P: 5,000
Hi,

I've a stored Procedure, it fetches data from a temp table
Using that data it queries the DB using a single select statement
then it inserts into DB

But the peroformance is very poor
I'm using IBM db2

please give ur suggestions to improve the performance
Next time, try posting to the DB2 forum.
Nov 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.