Dec 4, 2017
Enabling Parallelism for a SQL Query
Enabling Parallelism for a SQL Query
You found a query running on large table, you want to enable parallelism to check its speed after normal execution.
For using the parallelism on SQL Query, you need to explicitly defines hints on the SQL Query for forcefully used the parallel operations.
Two way to be used parallel operation on SQL Query as 1. Parallel Hint 2. Parallel_index Hint
Parallel hint…
View On WordPress