0

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
Andrei Rînea
  • 310
  • 5
  • 17

1 Answers1

2

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.

Evan Anderson
  • 141,881
  • 20
  • 196
  • 331