Home / server / Questions / 84889
Accepted
Andrei Rînea
Asked: 2009-11-16 02:51:20 +0800 CST

What is star query optimization?

  • 772

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere.

Could this be a feature that optimizes a query like :

SELECT * FROM Table
sql-server

1 Answers

  1. Best Answer

    It's a business intelligence feature, allowing the query planner to make better decisions when performing queries on star schema style databases, typically used in business intelligence / data warehouse implementations.

    Some sparse background is available in this blogs.msdn.com post, but the article they link to for deeper information is gone.

    • 2