SQL Server 2008 Star Join Query Optimization

Leave a comment (1) Go to comments

SQL Server 2008 will offer much more powerful relational data warehousing capabilities than its predecessor. As part of the development effort for the star join optimization in SQL Server 2008, Microsoft performed a number of performance studies based on benchmark and real customer workloads and made a significant enhancement.

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

Understand – SQL Server 2008 Star Join Query Optimization (Video)

As per the Microsoft, they done a deep testing and It’s worth looking at the results from three of these workloads in the following figures.

SQL Server 2008 Star Join Query Optimization Star Join Query Optimization sql server Query Selectivity sql server Data Warehousing Star query enhancement sql server Bitmap Filter SQL Server 2008 Star Join Query Optimization SQL Server 2008 Star Join Query SQL Server 2008 Star Join SQL Server 2008 Query Optimization sql server 2008 query engine enhancement sql server 2008 Join Optimization Query Selectivity

Figure : Performance improvements with star join optimization

As the figure shows, all workloads improve significantly, by 12 up to 30 percent. While your individual mileage will vary, Microsoft expect decision support workloads against the SQL Server Engine to improve by approximately 15–20 percent based on the extension of the star join-specific optimizations that are new in SQL Server 2008.

EOF - SQL Server 2008 Star Join Query Optimization, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment


Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: