Foreign Keys and the query optimizer in SQL Server 2K8
Page 1 of 1
Foreign Keys and the query optimizer in SQL Server 2K8
I am using SQL Server 2008. 2K8 has a star optimizer to improve the performance of queries. I've read that it improves query performance by 15-30%. Do foreign keys have to be defined on the fact tables in order for the star optimizer to be effective?
In the past, I've never defined the foreign keys as I didn't see any benefit. I plan to define them on the current database (turning off referential integrity) in the near future. I was wondering if defining them would lead to a performance improvement or is the DBS already benefitting from the optimizer?
In the past, I've never defined the foreign keys as I didn't see any benefit. I plan to define them on the current database (turning off referential integrity) in the near future. I was wondering if defining them would lead to a performance improvement or is the DBS already benefitting from the optimizer?
Jeff Smith- Posts : 471
Join date : 2009-02-03
Re: Foreign Keys and the query optimizer in SQL Server 2K8
I found the answer - Foreign Keys do not have to be defined in order for SQL Server 2K8 to use the Star Optimizer, but defining the Foreign Keys on the fact tables will make the optimizer work better.
Jeff Smith- Posts : 471
Join date : 2009-02-03
Similar topics
» Any Benefit to Defining Foreign Keys in SQL Server without enforcing foreign key constraint in SQL Server
» Factless fact table with null foreign keys
» Derived Fact table with additional measures / foreign keys ... ?
» Fact Table with huge number of Blank (or Empty) foreign keys
» Foreign Key Constraints
» Factless fact table with null foreign keys
» Derived Fact table with additional measures / foreign keys ... ?
» Fact Table with huge number of Blank (or Empty) foreign keys
» Foreign Key Constraints
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|