Sign in
Tips, Tricks, and Advice from the SQL Server Query Processing Team
The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
Compilation time
data warehousing
Distinct aggregation
Estimate Rows
ETW
Hash Join
Indexing
Memory Management
OLAP
OLTP
optimizer
Query cost
query memory
query optimization
Query plan
Showplan
Showplan_XML
SQL Profiler
SQL Server 2005
SQL Trace
Star Join
Statistics Profile
Statistics XML
Tracing
Archive
Archives
March 2010
(1)
February 2010
(1)
August 2009
(1)
September 2008
(1)
June 2007
(1)
May 2007
(2)
April 2007
(1)
February 2007
(1)
January 2007
(2)
December 2006
(2)
November 2006
(6)
October 2006
(5)
September 2006
(4)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Tips, Tricks, and Advice from the SQL Server Query Processing Team
How to Check Whether the Final Query Plan is Optimized for Star Join Queries?
Posted
over 6 years ago
by
SQL Server Query Processor Team
4
Comments
The star join optimization technique is an index based optimization designed for data warehousing scenarios to make optimal use of non-clustered indexes on the huge fact tables. The general idea is to use the non-clustered indexes on the fact table to...
Page 1 of 1 (1 items)