Best Practice For Indexes

kmorasoabi at 21h59
17
Jun
2009
Best Practice For Indexes

Many books have very different opinions on what indexes you should create for a typical star schema having the following generic structure:

Fact table
fact_surrogate_key
dim1_sk
dim2_sk
dim2_bk (business key -- assuming hybrid type 2 scd, joins both with sk and bk with current_indicator=y constraint)
dim3_sk
...
measure1
measure2

Dim1
dim1_sk
attr

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Data Warehouse - Indexes
Hi, I am currently at the point where I need to think about Indexes on my data warehouse. We are currently using SQL Server 2005. As a general rule of thumb would the following hold true (Please note that the reporting requirements are still
null values best practice digest
Hi all, i read all the post and design tips about null values management. Can you tell m if the following statements are right or wrong for you : Dimension attributes null values management : For string dimension attributes, use : "Not
ETL Load - Dropping Indexes and Constraints
Hi, I am currently working on an ETL solution using BODI and SQL Server 2005. Our data warehouse is very small (no more than 5mb) currently and expected growth over the next year is not going to exceed 15mb. Based on the above volume estimates does
Best Practice Database Schema/user layout
Just wanted to check to see how others have structured the typical data warehouse schema layout. I know much of this is based on the individual project requirments, but I just wanted to see how others have done it. I was thinking about the following
Stat 210: Supplement to Basic Practice of Statistics 10th edition by darcy mays
I am selling the book for Stat 110- Basic Practice of Statistics. This is the 10th edition of the book. I am asking 25 dollars or best offer for it. It goes $42.25 new at the book store. The book is in excellent condition (like new) with no
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Best Practice For Indexes"

This topic has been viewed 1393 times.

Last message :
17/06/2009 at 21h59 by "kmorasoabi"