|
|
|
|
|
|
|
|
|
Re: Want to execute 900 query's, is there any faster way to execute [message #670113 is a reply to message #670108] |
Wed, 06 June 2018 15:08 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
What are you going to do with the results. If they are being loaded into a table then write a script to submit 900 scheduler jobs running the selects. The database will run up to the maximum number of job processes allowed in the database at the same time. But to give better advice, we really need to know why you need to run 900 queries. If they are similar except for key values (for example) then they can probably be combined into one massive query. Any additional information would be appreciated.
|
|
|