You're experiencing difficulty in creating an indexed view. Ok, so backtrack for a moment. View indexing is a performance measure. Somewhere, you're attempting to use these two tables, JOINed or UNIONed or whatever, in another query. Can you show an example of such a query, and if possible an actual execution plan? In the event that the indexed view you would ideally like to see is impossible to create, there may well be alternative means of accelerating the queries that the view would by used by.