Sliding Window Merge Join

Database
Enthusiast

Sliding Window Merge Join

Are sliding window merge joins always costly. We see lots of queries that show SWMJ in their explian. I know it is basically when we join the two tables that have differenet PPI or join a PPI table with NPPI table. Can we improve the SWMJ's by any chance.

Thank You,