peacesells (1/8/2013)
what columns would be best suitable to have indexes on in dimension and fact tables.
indexs should include column which are part of
Where
order by
group by
JOINs ON clause.
partition by......etc
and column which are invole in SELECT should be part of INCLUDE of covering index. thats the generic answer of your generic question 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)