Successful execution of two queries, one after the other

Asked By Sarahjeanne 0 points N/A Posted on - 11/07/2011

I need to execute two queries, one after the other. If, almost all results of both the queries overlap and if the result of first query is stored in the memory, will it reduce the execution time of the second query?

• Status: Open
• Question Views: 804
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Internet

Answered By Mahesh Babu 20 points N/A #106513

Successful execution of two queries, one after the other

Hello Sarahjeanne,

It would have been easier if you could have stated the application you are using for programming so as we can figure out how to about the way you will execute the queries easily. For instance are you using java, visual basic, oracle and so forth?

But in case you are using visual basic or sql, then you will have to create a procedure that will allow the second query to be executed immediately the first one finishes and then embed it in the code. You will have to use the IMMEDIATE command in that one. You can also separate the queries with commas and see if they can work that way.

__

Regards
Mahesh Babu

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/23/2011
• Question Category: Internet