1) Any ideas on how to speed up the main fact table? My clustered index is on the year first then the account number. Ive even tried non-clustered, but with no luck. or if I cant get the index on the main table to speed up
What did you try for the non clustered index? If you are trying to compare month over month data I would imagine you would want at least the year + month in the index if not just the entire date.