OraFAQ Forum: Performance Tuning » Running many queries in a single shot

Home » RDBMS Server » Performance Tuning » Running many queries in a single shot

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running many queries in a single shot [message #65735]

Thu, 16 December 2004 17:24

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

�

Report message to a moderator

Re: Running many queries in a single shot [message #65740 is a reply to message #65735]

Sat, 18 December 2004 14:58

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.

Report message to a moderator

Re: Running many queries in a single shot [message #65741 is a reply to message #65740]

Sun, 19 December 2004 04:43

Supraja
Messages: 18
Registered: August 2004

Junior Member

union all will defintely won't help me

Report message to a moderator

Re: Running many queries in a single shot [message #65755 is a reply to message #65735]

Tue, 21 December 2004 21:24

K. Prakash babu
Messages: 46
Registered: July 2001

Member

Write a procedure to run all the queries at once

Report message to a moderator

Re: Running many queries in a single shot [message #65756 is a reply to message #65755]

Tue, 21 December 2004 21:26

Supraja
Messages: 18
Registered: August 2004

Junior Member

Thanks a lot, I will try it and get back to u

Report message to a moderator

Previous Topic:	Performance for purging
Next Topic:	Temporary tables . Delete or Truncate?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 20:18:24 CST 2024