Here's a blog post I wrote for our company blog on join optimization in data modules.
This concept is particularly useful if you are joining two different data sources in a data module.
Check out the other posts on our site. Lots of fantastic content up there for Cognos Analytics and Planning Analytics.