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.