Home » RDBMS Server » Performance Tuning » Running many queries in a single shot
Running many queries in a single shot [message #65735] Thu, 16 December 2004 17:24 Go to next message
Supraja
Messages: 18
Registered: August 2004
Junior Member
Hi

 I had a query which was fetching 120 products from in 15 product types. Since that query was not working. I broke the query into 120 queries.

 I generated report. Now there is one small bug. So I need to run all those queries once again.

 Is ther any tool availabe which can do this job for me

 
Re: Running many queries in a single shot [message #65740 is a reply to message #65735] Sat, 18 December 2004 14:58 Go to previous messageGo to next message
someone
Messages: 7
Registered: November 2002
Junior Member
you may either correct your first query or join your 120 queries using union all. I would prefer the first solution.
Re: Running many queries in a single shot [message #65741 is a reply to message #65740] Sun, 19 December 2004 04:43 Go to previous messageGo to next message
Supraja
Messages: 18
Registered: August 2004
Junior Member
union all will defintely won't help me
Re: Running many queries in a single shot [message #65755 is a reply to message #65735] Tue, 21 December 2004 21:24 Go to previous messageGo to next message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
Write a procedure to run all the queries at once
Re: Running many queries in a single shot [message #65756 is a reply to message #65755] Tue, 21 December 2004 21:26 Go to previous message
Supraja
Messages: 18
Registered: August 2004
Junior Member
Thanks a lot, I will try it and get back to u
Previous Topic: Performance for purging
Next Topic: Temporary tables . Delete or Truncate?
Goto Forum:
  


Current Time: Wed Sep 23 14:59:13 CDT 2020