Skip to Content
0
Former Member
Sep 10, 2008 at 11:10 PM

Parallel Processing

911 Views

Hi All - We have a program in which we have a select statement

thats joins 3 tables and fetches large amount of data. This program is quite frequently run and takes about a couple minutes each time. Just wanted to know if we can use parallel processing for this.

1. Is it possible to use the parallel processing technique for a Select statement?

2. Will fetching the data using Packet size option improve performance?

3. Can Parallel processing be used to programs run in foreground?

Regards.

Sam.