Merge Joining on non-indexed column.

Analytics
Enthusiast

Merge Joining on non-indexed column.

In a situation when Merge Joining is un-Avoidable on non-indexed column, Is using Collect Stats on those column is of any use.

2 REPLIES
Junior Contributor

Re: Merge Joining on non-indexed column.

There's no situation where a Merge join is unavoidable :-)

Merge Join is only one possible way for the optimizer to do a join, there are always others like Product or Hash Join.

But stats on the join columns will help the optimizer to choose the best option.

Enthusiast

Re: Merge Joining on non-indexed column.

Thanks! Dieter.