Showing posts with label merge parallel. Show all posts
Showing posts with label merge parallel. Show all posts

Monday, July 20, 2020

Merge is not using Parallel hint

if you are using table alias then use parallel(alias) not parallel(table_name)

also if query is using index in plan then it will not use parallelism
if you want to use parallel forcefully then use full(alias) along with parallel hint.

Followers