I would confirm that there are indexes on all of the date columns. If not, just create simple nonclustered indexes on each individual date column.

When selecting from the view...