SQL Server 2008 Star Join Query Optimization
Full Detailed Article for "SQL Server 2008 Star Join Query Optimization" is available at :
http://sqlserver-training.com/sql-ser...
Follow us at more Updates at
-----------------------------------------
Website : http://sqlserver-training.com/
Twitter : / dbatag
Facebook : / dbatag
Linked In : / dbatag
================================
Star Join Query Optimization is a new feature of SQL Server 2008 Enterprise Edition. This mechanism uses bitmap filtering for improving the performance of some types of queries by the effective retrieval of rows from fact tables.
SQL Server 2008 Star Join Query has
Improved Query Response Times
Automatically Implemented
Query Selectivity
Bitmap Filter -- Integer Data Types