Simon, This all looks good, and at the risk of being slightly off-topic for this thread, I just wanted to mention..
* Simon Riggs (si...@2ndquadrant.com) wrote: > Current proposal ends there, but there is a further optimization that > allows us to remove the join altogether if > * There is a FK between Fact and Dim It'd be great if we could start by looking for the above requirement and then doing join-removal when it exists and no columns from Dim are referenced (outside of the FK reference, which must result in 'true' or we've screwed something up). I had been looking at this about a month ago and just ran out of time to play with it, but it doesn't seem like it'd be terribly difficult to do.. Thanks, Stephen
signature.asc
Description: Digital signature