Hi
I would like to check the correct usage of parallel hint in merge statement. I am on oracle 11g. I have enabled parallel dml. I would like to check which ones is the correct usage:
1. merge /*+parallel(tgt,16)*/ into tableA tgt using (select /*+parallel (b,16) */ * from b) src
on(tgt.col1 = src.col1)
when matched....
2.
merge /*+parallel(tgt,16)*/ into tableA tgt using (select * from b) src
on(tgt.col1 = src.col1)
when matched....
Is it sufficient that I use parallel hint in merge statement and not use in select statement?
please clarify
Thanks
kumar