InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 23:33:59 GMT20http://www.sqlservercentral.com/Forums/Topic1337066-363-1.aspxAs a rule of thumbs it should be an index per each dimension pointing to a specific fact table.Remember that the function of the dimensions is to provide the means to slice-and-dice the measures stored in the fact table therefore a sound indexing strategy is a must.A single index on all dimensions would help only queries using all dimensions to filter/acces the data - which is not usually the case.Sat, 04 Aug 2012 13:54:25 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1337066-363-1.aspxWhich data column did you want to remove exactly?And which column do you want to speed up?Typically, indexes will enhance query performance, if created correctly.Mon, 30 Jul 2012 00:09:15 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1337066-363-1.aspxhi my fact table consist of 4 dimensions. I have a composite primary key on all the 4 dimensions. the time dimension is of 15 minutes and it is one of the dimensins. i have one more date column says just the date without 15 minutes just to tell which date it is.it has been designed already and now i can't remove the other date column. and it has been used in reports and other queris.my question is to speed up the activity should i create an index on the same?Thanks,Regards,AmiMon, 30 Jul 2012 00:01:01 GMTAnamika