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?