Mohammed Abdul Afroze

• Nov 1st, 2007

 

When we set to PARALLEL_ADAPTIVE_MULTI_USER=true, enables an adaptive algorithm designed to improve performance in multiuser environments that use parallel execution. The algorithm automatically reduces the request degree of parallelism based on the degree at the system load at query startup time.