Hi,

1. You don't have to add all fields/columns, unless you must to. Indexed view is very close to table. It's biggest utility comes when the goal is to optimize aggregate operations.

2. Follow the same rules for designing indexes as for tables (e.g. http://www.sqlservercentral.com/articles/Indexing/68563/).

3. Consider that indexes updates are affecting views same as tables. However, nonclustered indexes are useful, but try to cover as much as possible with min number of indexes.

Consider the table size, which in your case is pretty big.

Regards,

Igor