Peter.VanderWoude's blog

Hash join anti vs Nested loop join anti

This post shows you details about a specific case where 'hash anti join' is defeated by 'nested loop anti join'.
The initial problem came to light in a very large BW system running on Oracle 11.2.0.4 when several BW loads (making use of older data in the BW system) reported missing dimension ids in the dimension tables.

Subscribe to RSS - Peter.VanderWoude's blog