SAP BW 7 and SQL Server 2008 Star Join Optimization

    Table of contents : 1. Intro 2. Sample query using SQL Server 2005 3. Sample query with star join optimization using SQL Server 2008 R2 4. like 3. but with row compression 5. Sample query with non-optimized bitmaps using SQL Server 2008 R2 6. Could a query with star join optimization be slower… Read more